9. Click: to'lovlar holati bo'yicha hisobot
OsonAgregatsiyalarClick
Click to'lov tizimidagi tranzaksiyalar payments jadvalida.
Har bir status uchun tranzaksiyalar sonini (cnt) va umumiy summasini (total)
hisoblang.
Natijani umumiy summa bo'yicha kamayish tartibida saralang.
Jadval: payments
| Ustun | Turi |
|---|---|
| id | INT PK |
| status | VARCHAR |
| amount | NUMERIC(12,2) |
Ustun nomlari: status, cnt, total.
Namuna ma'lumotlar
sample-basic
payments
| idINT | statusVARCHAR(20) | amountNUMERIC(12,2) |
|---|---|---|
| 1 | SUCCESS | 1000 |
| 2 | SUCCESS | 2000 |
| 3 | SUCCESS | 500 |
| 4 | PENDING | 3000 |
| 5 | FAILED | 250 |
| 6 | FAILED | 100 |
Kutilgan natija
| cnt | total | status |
|---|---|---|
| 3 | 3500 | SUCCESS |
| 1 | 3000 | PENDING |
| 2 | 350 | FAILED |
sample-single-status
payments
| idINT | statusVARCHAR(20) | amountNUMERIC(12,2) |
|---|---|---|
| 1 | SUCCESS | 100 |
| 2 | SUCCESS | 200 |
| 3 | SUCCESS | 300 |
Kutilgan natija
| cnt | total | status |
|---|---|---|
| 3 | 600 | SUCCESS |
sample-two
payments
| idINT | statusVARCHAR(20) | amountNUMERIC(12,2) |
|---|---|---|
| 1 | PENDING | 5000 |
| 2 | FAILED | 1500 |
Kutilgan natija
| cnt | total | status |
|---|---|---|
| 1 | 5000 | PENDING |
| 1 | 1500 | FAILED |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.