Skip to content

Data Analytics

SQL aggregation

Summarize records with SQL while preserving the intended population and grouping.

With Zoonk, your plan starts at this chapter and fits your schedule.

Build my plan

Start free, no account needed.

Where this chapter sits in the course

Lessons

Chapter 10 of 16 · 6 short lessons · 24 min
  1. 1SQL aggregate functions4 min
  2. 2GROUP BY3 min
  3. 3WHERE and HAVING4 min
  4. 4Distinct counts3 min
  5. 5Rates in SQL4 min
  6. 6Challenge: SQL aggregation6 min

What you'll learn

  • Calculate SQL aggregates for defined groups
  • Apply row and group filters correctly
  • Calculate distinct counts and rates

Your plan from this chapter

It follows the course from here, at your pace, with reviews before you forget.

Build my plan

Start free, no account needed.