SQL vazifa to'plami 5.2 Darajasi
Quyidagi jadvallar berilgan:
| id | user_id | amount | payment_type | bonuses_increases | bonuses_decreases | created_at |
| 1 | 3 | 80.50 | CARD | 0.85 | 0.00 | 2023-09-10 |
| 2 | 2 | 1700.13 | CARD | 17.00 | 1000.00 | 2023-09-27 |
| 3 | 5 | 214.34 | CARD | 2.14 | 50.00 | 2023-09-01 |
| 4 | 1 | 596.00 | CASH | 5.96 | 0.00 | 2023-10-08 |
| 5 | 3 | 800.18 | CASH | 8.00 | 0.00 | 2023-09-30 |
| 6 | 3 | 120.18 | CARD | 1.20 | 50.18 | 2023-10-03 |
| 7 | 2 | 1000.12 | CASH | 10.00 | 0.00 | 2023-09-20 |
| 8 | 1 | 81.78 | CASH | 8.17 | 0.00 | 2023-09-25 |
| 9 | 4 | 509.12 | CARD | 5.91 | 100.12 | 2023-10-07 |
| 10 | 5 | 100.50 | CASH | 1.00 | 0.00 | 2023-10-08 |
| id | name | age | city |
| 1 | Aaron | 43 | New-York |
| 2 | Marina | 20 | Minsk |
| 3 | Max | 23 | Kyiv |
| 4 | Catherine | 30 | Berlin |
| 5 | Andrew | 18 | Berlin |
Ularni quyidagi masalalarni yeching:
Foydalanuvchilar va ularning tranzaksiyalari ro'yxatini oling.
Tranzaksiyalar identifikatorlari va ularni amalga oshirgan foydalanuvchilarning ismlari ro'yxatini birinchi 5 ta tranzaksiya uchun oling.
Xaridlarni kartadan to'lagan foydalanuvchilar ismlari va tranzaksiya identifikatorini oling.
Xaridlarni naqd puldan to'lagan foydalanuvchilar ismlari va tranzaksiya identifikatorini oling.
Boshqa barcha foydalanuvchilarga nisbatan xaridlar summasi eng yuqori bo'lgan foydalanuvchi ismini oling.
