GROUP BY and HAVING

SQL & databases · lesson 6 of 8

Lesson 6 needs a free account

The first 3 lessons of every track are open to everyone. From here on Yanjye has to remember where you stopped, mark your exam and put your name on the certificate — so it needs to know who you are.

This lesson: Group rows and filter the groups.

Create a free account I already have one

Free — the lessons and the exam never cost anything
Your progress is saved across every device
Pass the exam and earn a certificate anyone can verify

Or go back to SQL & databases and finish the free lessons first.

All lessons in this track

1
What SQL is and how tables work ~15 min
2
SELECT and WHERE ~25 min
3
ORDER BY and LIMIT ~20 min
4
INSERT, UPDATE and DELETE ~30 min account needed
5
Aggregate functions ~25 min account needed
6
GROUP BY and HAVING ~25 min account needed
7
JOINs ~35 min account needed
8
Creating tables and keys ~25 min account needed

Advertisement Yanjye Learn a new digital skill this week ICT, programming and professional courses with graded weekly assignments. Start free

GROUP BY and HAVING

Lesson 6 needs a free account

All lessons in this track

Latest opportunities

Popular topics

For learners

Partners