SQL vazifa to'plami 4.6 Darajasi
Quyidagi jadval berilgan:
| id | user_id | amount | payment_type | bonuses_increases | bonuses_decreases | created_at |
| 1 | 12355 | 80.50 | CARD | 0.85 | 0.00 | 2023-09-10 |
| 2 | 52421 | 1700.13 | CARD | 17.00 | 1000.00 | 2023-09-27 |
| 3 | 125355 | 214.34 | CARD | 2.14 | 50.00 | 2023-09-01 |
| 4 | 9392 | 596.00 | CASH | 5.96 | 0.00 | 2023-10-08 |
| 5 | 23511 | 800.18 | CASH | 8.00 | 0.00 | 2023-09-30 |
| 6 | 125355 | 120.18 | CARD | 1.20 | 50.18 | 2023-10-03 |
| 7 | 52421 | 1000.12 | CASH | 10.00 | 0.00 | 2023-09-20 |
| 8 | 125355 | 81.78 | CASH | 8.17 | 0.00 | 2023-09-25 |
| 9 | 52421 | 509.12 | CARD | 5.91 | 100.12 | 2023-10-07 |
| 10 | 125355 | 100.50 | CASH | 1.00 | 0.00 | 2023-10-08 |
Uning uchun quyidagi masalalarni yeching:
Barcha cheklarni foydalanuvchilar bo‘yicha guruhlang va cheklar yig‘indisini hisoblang. Cheklar yig‘indisi 300 dan katta bo‘lgan foydalanuvchilarni tanlang.
Barcha cheklarni to‘lov turi bo‘yicha guruhlang. To‘lov turini va cheklar yig‘indisini yaxlitlangan holda tanlang, shuningdek yig‘indi 5000 dan katta bo‘lish shartini qo‘ying.
'2023-10-01' dan keyin yaratilgan barcha cheklarni to‘lov turi bo‘yicha guruhlang. To‘lov turini va cheklar yig‘indisini yaxlitlangan holda tanlang, shuningdek yig‘indi 4500 dan kichik bo‘lish shartini qo‘ying.
