17 of 100 menu

SQL Taskbook Level 2.7

Given a table:

orders
id name total date
1 Aaron 999 2023-08-31
2 Max 140 2023-09-28
3 Catherine 560 2023-05-31
4 Catherine 240 2023-03-22
5 Aaron 500 2023-01-24

Solve the following tasks for it:

Display a list of unique customers who have placed orders.

Find the total number of orders made by each customer.

Display a list of orders made in the current year.

Find the average order size (amount) for the last 3 months.

Display orders where the amount is greater than 1000 dollars.

English
AfrikaansAzərbaycanБългарскиবাংলাБеларускаяČeštinaDanskDeutschΕλληνικάEspañolEestiSuomiFrançaisहिन्दीMagyarՀայերենIndonesiaItaliano日本語ქართულიҚазақ한국어КыргызчаLietuviųLatviešuМакедонскиMelayuမြန်မာNederlandsNorskPolskiPortuguêsRomânăРусскийසිංහලSlovenčinaSlovenščinaShqipСрпскиSrpskiSvenskaKiswahiliТоҷикӣไทยTürkmenTürkçeЎзбекOʻzbekTiếng Việt
We use cookies for website operation, analytics, and personalization. Data processing is carried out in accordance with the Privacy Policy.
accept all customize decline