Level 4 · Summarize data

Use groups and aggregates to make sense of many rows.

Complete the core concepts in level 3 before continuing.

1. Practice: Product statistics
2. Practice: Calculate item amounts
3. Practice: Paid sales revenue
4. Count products by category · Practice: Count products by category
5. Practice: Spending per customer
6. Practice: Find top customers
7. Practice: Avoid counting orders twice
8. Practice: Use the original sale price
9. Practice: Product count
10. Practice: Sum of prices
11. Practice: Average price
12. Practice: Lowest price
13. Practice: Highest price
14. Practice: Order item amounts
15. Practice: Total for order 101
16. Practice: Average by category
17. Practice: Minimum by category
18. Practice: Maximum by category
19. Practice: Stock by category
20. Practice: Customers by city
21. Practice: Counts by order status
22. Practice: Orders per customer
23. Practice: Items per order
24. Practice: Quantity per order
25. Practice: Amount per order
26. Practice: Quantity per product
27. Practice: Revenue per product
28. Practice: Categories with many products
29. Practice: Customers with many orders
30. Practice: Customer orders and items

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