18. Beeline: balansi manfiy faol abonentlar
OsonSELECT asoslariBeeline
Mobil operator abonentlari subscribers jadvalida.
Faol (is_active = true) va balansi manfiy bo'lgan abonentlarning
phone, full_name, balance ustunlarini qaytaring.
Natijani balans bo'yicha o'sish tartibida saralang (eng katta qarz birinchi).
Jadval: subscribers
| Ustun | Turi |
|---|---|
| id | INT PK |
| phone | VARCHAR |
| full_name | VARCHAR |
| balance | NUMERIC(10,2) |
| is_active | BOOLEAN |
Diqqat: balansi aniq 0 bo'lgan abonent qarzdor hisoblanmaydi.
Namuna ma'lumotlar
sample-basic
subscribers
| idINT | phoneVARCHAR(20) | full_nameVARCHAR(60) | balanceNUMERIC(10,2) | is_activeBOOLEAN |
|---|---|---|---|---|
| 1 | +998901000001 | Aziz | -15000.5 | true |
| 2 | +998901000002 | Bek | 20000 | true |
| 3 | +998901000003 | Dilnoza | -3000 | true |
| 4 | +998901000004 | Kamola | -99999.99 | false |
Kutilgan natija
| phone | balance | full_name |
|---|---|---|
| +998901000001 | -15000.5 | Aziz |
| +998901000003 | -3000 | Dilnoza |
sample-one-neg
subscribers
| idINT | phoneVARCHAR(20) | full_nameVARCHAR(60) | balanceNUMERIC(10,2) | is_activeBOOLEAN |
|---|---|---|---|---|
| 1 | +998901000001 | Solo | -500 | true |
| 2 | +998901000002 | Plus | 100 | true |
Kutilgan natija
| phone | balance | full_name |
|---|---|---|
| +998901000001 | -500 | Solo |
sample-none
subscribers
| idINT | phoneVARCHAR(20) | full_nameVARCHAR(60) | balanceNUMERIC(10,2) | is_activeBOOLEAN |
|---|---|---|---|---|
| 1 | +998901000001 | A | 100 | true |
| 2 | +998901000002 | B | -50 | false |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.