1. SQL foundations
Learn selection, filtering, ordering and aggregation with the sample shop. Work through these in order, then return to any exercise for revision.
- Select customer names
- Filter by country
- Compare numbers
- Order by descending price
- Find the top three
- Find unique categories
- Count orders
- Sum order totals
- Calculate an average
- Group orders by status