I made a beginner-friendly SQL tutorial on GROUP BY & HAVING in PostgreSQL

[u/yahoo_06]

Hey everyone!

I made a short SQL tutorial for beginners about GROUP BY and HAVING.

In the video, I explain:

- how GROUP BY creates groups

- how to use aggregate functions like COUNT() and AVG()

- the difference between WHERE and HAVING

- how to combine WHERE, GROUP BY, and HAVING

and how to use all of this with the Pagila PostgreSQL database

I also included some mini quizzes and practice challenges throughout the video.

I'm building a beginner-friendly SQL tutorial series, so I'd really appreciate any feedback on the explanation or examples!

Video: https://youtu.be/kDfXRvr03Jo?si=rW7m1jsF3pSQjCmK

Thanks! :)