Kiwango cha 8.3 cha Kitabu cha Kazi cha SQL
Tabla zifuatazo zimetolewa:
| id | total | client_id | date |
|---|---|---|---|
| 1 | 700 | 5 | 2023-11-11 |
| 2 | 500 | 1 | 2023-01-12 |
| 3 | 340 | 1 | 2023-01-13 |
| 4 | 1999 | 4 | 2022-10-11 |
| 5 | 875 | 3 | 2023-05-25 |
| 6 | 201 | 2 | 2023-04-30 |
| 7 | 700 | 2 | 2022-12-25 |
| 8 | 821 | 3 | 2023-07-03 |
| 9 | 219 | 5 | 2023-11-11 |
| 10 | 329 | 1 | 2023-03-31 |
| 11 | 986 | 3 | 2023-02-28 |
| id | name |
|---|---|
| 1 | John |
| 2 | Lolita |
| 3 | Ann |
| 4 | Alex |
| 5 | Matthew |
Tatua matatizo yafuatayo kwa ajili yao:
Задание 1
Tafuta mteja aliyefanya idadi kubwa zaidi ya maagizo, na uwasilishe jumla ya kiasi cha maagizo yake yote, pamoja na jina lake na tarehe ya agizo lake la kwanza.
Задание 2
Badilisha tatizo la awali ili pia utafute mteja aliye na tarehe ya zamani zaidi ya agizo lake la kwanza na tarehe ya baadaye zaidi ya agizo lake la mwisho, na uwaonyeshe.