15. Bank: mijozning o'rtachasidan yuqori tranzaksiyalar
O'rtachaSubquery'larKapitalbank
Bank tranzaksiyalari transactions jadvalida.
Summasi o'sha mijozning o'rtacha tranzaksiya summasidan katta bo'lgan
tranzaksiyalarni toping: client_name, amount.
Diqqat: o'rtacha umumiy emas, har mijoz uchun alohida hisoblanadi.
Saralash: client_name o'sish, amount kamayish.
Jadval: transactions
| Ustun | Turi |
|---|---|
| id | INT PK |
| client_name | VARCHAR |
| amount | NUMERIC(14,2) |
Namuna ma'lumotlar
sample-basic
transactions
| idINT | client_nameVARCHAR(50) | amountNUMERIC(14,2) |
|---|---|---|
| 1 | Aziz | 100000 |
| 2 | Aziz | 500000 |
| 3 | Aziz | 250000 |
| 4 | Bek | 200000 |
| 5 | Bek | 800000 |
| 6 | Bek | 150000 |
Kutilgan natija
| amount | client_name |
|---|---|
| 500000 | Aziz |
| 800000 | Bek |
sample-single-txn
transactions
| idINT | client_nameVARCHAR(50) | amountNUMERIC(14,2) |
|---|---|---|
| 1 | Aziz | 100000 |
sample-all-equal
transactions
| idINT | client_nameVARCHAR(50) | amountNUMERIC(14,2) |
|---|---|---|
| 1 | Aziz | 300000 |
| 2 | Aziz | 300000 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.