23. Bank: hisoblar ochilgan shaharlar
OsonSELECT asoslariKapitalbank
Bank hisoblari accounts jadvalida.
Hisob ochilgan noyob shaharlar ro'yxatini qaytaring — city ustuni.
Har bir shahar bir marta chiqishi kerak.
Natijani alifbo tartibida saralang.
Jadval: accounts
| Ustun | Turi |
|---|---|
| id | INT PK |
| client_name | VARCHAR |
| city | VARCHAR |
| balance | NUMERIC(14,2) |
Namuna ma'lumotlar
sample-basic
accounts
| idINT | client_nameVARCHAR(60) | cityVARCHAR(50) | balanceNUMERIC(14,2) |
|---|---|---|---|
| 1 | Aziz | Toshkent | 1500000 |
| 2 | Bek | Samarqand | 200000 |
| 3 | Dilnoza | Toshkent | 50000 |
| 4 | Kamola | Buxoro | 999999.99 |
Kutilgan natija
| city |
|---|
| Buxoro |
| Samarqand |
| Toshkent |
sample-single
accounts
| idINT | client_nameVARCHAR(60) | cityVARCHAR(50) | balanceNUMERIC(14,2) |
|---|---|---|---|
| 1 | Aziz | Xiva | 0 |
Kutilgan natija
| city |
|---|
| Xiva |
sample-dups
accounts
| idINT | client_nameVARCHAR(60) | cityVARCHAR(50) | balanceNUMERIC(14,2) |
|---|---|---|---|
| 1 | A | Andijon | 10 |
| 2 | B | Andijon | 20 |
| 3 | C | Andijon | 30 |
Kutilgan natija
| city |
|---|
| Andijon |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.