3. Kunlik savdoning yig'indi jami
O'rtachadaily_sales (sale_date, amount) jadvali har kungi savdo summasini saqlaydi.
Vazifa: har sana uchun o'sha kungacha (shu kun ham) bo'lgan savdolarning yig'indi jamisini hisoblang. Natija ustunlari: sale_date, running_total. Natijani sale_date bo'yicha o'sish tartibida qaytaring.
Jadval: daily_sales
| Ustun | Turi |
|---|---|
| sale_date | DATE |
| amount | INT |
Namuna ma'lumotlar
sample-main
daily_sales
| sale_dateDATE | amountINT |
|---|---|
| 2025-01-01 | 100 |
| 2025-01-02 | 250 |
| 2025-01-03 | 75 |
Kutilgan natija
| sale_date | running_total |
|---|---|
| 2025-01-01 | 100 |
| 2025-01-02 | 350 |
| 2025-01-03 | 425 |
sample-neg
daily_sales
| sale_dateDATE | amountINT |
|---|---|
| 2025-03-01 | 500 |
| 2025-03-02 | -200 |
| 2025-03-03 | 300 |
| 2025-03-04 | 0 |
Kutilgan natija
| sale_date | running_total |
|---|---|
| 2025-03-01 | 500 |
| 2025-03-02 | 300 |
| 2025-03-03 | 600 |
| 2025-03-04 | 600 |
sample-one
daily_sales
| sale_dateDATE | amountINT |
|---|---|
| 2025-05-10 | 42 |
Kutilgan natija
| sale_date | running_total |
|---|---|
| 2025-05-10 | 42 |
O'xshash masalalar
Konsol
Natijani ko'rish uchun so'rovni ishga tushiring.