Lesson 11 of 20

Group with GROUP BY and HAVING

Calculate an indicator by category, city or status, then filter the resulting groups.

22 minSQL Essentials

By the end of this lesson

  • Set the level of detail with GROUP BY
  • Distinguish between WHERE and HAVING
  • Build a readable aggregate ranking

SQL Essentials

Continue with the right access

“Group with GROUP BY and HAVING” is included from SQL Essentials.

30 free days of SQL Pro on registration, subject to the 33 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.