Level 5 · Explore with data

Combine subqueries and WITH to find your way through data.

Complete the core concepts in level 4 before continuing.

1. Products above average price · Practice: Products above average price
2. Practice: Complete a sales report
3. Practice: Products below average price
4. Practice: The most expensive products
5. Practice: The cheapest products
6. Practice: Stock below average
7. Practice: Stock above average
8. Practice: The largest stock
9. Practice: A product-count CTE
10. Practice: A category-stock CTE
11. Practice: A category-average CTE
12. Practice: A city-customer CTE
13. Practice: An order-quantity CTE
14. Practice: An order-amount CTE
15. Practice: A product-quantity CTE
16. Practice: An order-status CTE
17. Practice: The smallest order quantity
18. Practice: Unit prices above average
19. Practice: Unit prices below average
20. Practice: The highest unit price
21. Practice: The lowest unit price
22. Practice: Paid spending per customer
23. Practice: Paid revenue by category
24. Practice: Paid quantity per product
25. Practice: Sort order totals
26. Practice: Sort order quantities
27. Practice: Sort product quantities
28. Practice: Paid items by city
29. Practice: At least average price and stock
30. Practice: Below average price and stock

Practice opens in this page’s language. Change it in the practice options at any time.