44. Har mijozning oxirgi to'lovi
O'rtachaHar bir mijozning eng oxirgi to'lovini toping.
Ustunlar: client_name, paid_at, amount.
Saralash: client_name alifbo.
payments: id INT PK, client_name VARCHAR, paid_at DATE, amount NUMERIC(12,2)
Jadval: payments
| Ustun | Turi |
|---|---|
| id | INT PK |
| client_name | VARCHAR(60) |
| paid_at | DATE |
| amount | NUMERIC(12,2) |
Namuna ma'lumotlar
sample-basic
payments
| idINT | client_nameVARCHAR(60) | paid_atDATE | amountNUMERIC(12,2) |
|---|---|---|---|
| 1 | Aziz | 2025-01-05 | 150000 |
| 2 | Aziz | 2025-01-23 | 75000 |
| 3 | Aziz | 2025-02-10 | 220000 |
| 4 | Bek | 2025-01-05 | 90000 |
| 5 | Bek | 2025-01-23 | 140000 |
Kutilgan natija
| amount | paid_at | client_name |
|---|---|---|
| 220000 | 2025-02-10 | Aziz |
| 140000 | 2025-01-23 | Bek |
sample-single
payments
| idINT | client_nameVARCHAR(60) | paid_atDATE | amountNUMERIC(12,2) |
|---|---|---|---|
| 1 | Aziz | 2025-01-05 | 100000 |
Kutilgan natija
| amount | paid_at | client_name |
|---|---|---|
| 100000 | 2025-01-05 | Aziz |
sample-two-clients
payments
| idINT | client_nameVARCHAR(60) | paid_atDATE | amountNUMERIC(12,2) |
|---|---|---|---|
| 1 | Aziz | 2025-01-05 | 60000 |
| 2 | Aziz | 2025-01-23 | 420000 |
| 3 | Bek | 2025-01-05 | 310000 |
Kutilgan natija
| amount | paid_at | client_name |
|---|---|---|
| 420000 | 2025-01-23 | Aziz |
| 310000 | 2025-01-05 | Bek |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.