SQL problem kitabyň 8.2 derejesi
Tablisalar berlen:
| id | customer_id | order_date | total_amount |
|---|---|---|---|
| 1 | 2 | 2023-11-11 | 7500 |
| 2 | 1 | 2023-09-30 | 9000 |
| 3 | 2 | 2023-09-09 | 3200 |
| 4 | 1 | 2023-09-12 | 6700 |
| 5 | 2 | 2023-09-27 | 5500 |
| 6 | 3 | 2023-10-06 | 8200 |
| 7 | 4 | 2023-10-10 | 7300 |
| 8 | 5 | 2023-11-05 | 1200 |
| 9 | 4 | 2023-11-10 | 3600 |
| 10 | 1 | 2023-10-11 | 4500 |
| id | name |
|---|---|
| 1 | John |
| 2 | Andrew |
| 3 | Kevin |
| 4 | Mark |
| 5 | Eric |
Olara üçin aşakdaky meseleleri çözüň:
Sargyt mukdary iň ýokary we ähli müşderileriň ortaça sargyt mukdaryndan ýokary bolan müşderileri tapyň. Olaryň adyny we sargyt mukdaryny görkeziň.
Sargytlaryň mukdary iň ýokary, ýöne iki dürli aýdan köp bolmadyk sargyt eden müşderileri tapyň. Olaryň adyny we sargytlaryň jemi mukdaryny görkeziň.
