Vlak 9.4 van SQL-probleemoplosser
Die volgende tabelle word gegee:
| id | naam |
|---|---|
| 1 | Max |
| 2 | John |
| 3 | Erick |
| 4 | Joan |
| 5 | Mike |
| 6 | Elizabeth |
| 7 | Donella |
| 8 | Andrew |
| 9 | Erich |
| 10 | Mark |
| 11 | Kevin |
| id | gebruiker_id | balans |
|---|---|---|
| 1 | 5 | 5050 |
| 2 | 11 | 3030 |
| 3 | 4 | 3111 |
| 4 | 6 | 3000 |
| 5 | 7 | 1000 |
| 6 | 3 | 4100 |
| 7 | 1 | 2401 |
| 8 | 2 | 2540 |
| 9 | 10 | 2505 |
| 10 | 8 | 2200 |
| 11 | 9 | 2700 |
| id | rekening_id | transaksiestipe | bedrag | transaksiedatum |
|---|---|---|---|---|
| 1 | 11 | PAYMENT | 1504 | 2023-11-26 |
| 2 | 5 | PAYMENT | 690 | 2023-11-01 |
| 3 | 6 | PAYMENT | 1200 | 2023-11-02 |
| 4 | 7 | PAYMENT | 13000 | 2023-11-03 |
| 5 | 8 | PAYMENT | 1560 | 2023-11-22 |
| 6 | 4 | PAYMENT | 1999 | 2023-11-20 |
| 7 | 3 | PAYMENT | 2111 | 2023-11-11 |
| 8 | 2 | PAYMENT | 690 | 2023-11-24 |
| 9 | 9 | PAYMENT | 340 | 2023-11-25 |
| 10 | 10 | PAYMENT | 860 | 2023-11-20 |
| 11 | 1 | PAYMENT | 700 | 2023-11-21 |
Los die volgende probleme vir hulle op:
Vind gebruikers wie se balans met meer as 10% verminder het gedurende die afgelope maand.
