Master the SQL SELECT statement part 06: Aggregate Functions, GROUP BY and HAVING clauses

This video is part of a multi-part series on mastering the SQL SELECT statement. The SELECT statement, the most often used SQL command, is easy to learn yet difficult to master. Follow along with me and level up your database query super powers!

This video covers the Aggregate Functions, GROUP BY, and HAVING clauses, specifically
- Counting rows, values in columns, and unique values in columns
- Getting sums, minimum, maximum, and averages.
- NULL handling of the aggregate functions.
- The purpose of GROUP BY
- Understanding why columns in the projection (SELECT line) must be in the GROUP BY when an aggregate it used.
- Using the HAVING clause to filter rows after the GROUP BY operation.
- Differences between HAVING and WHERE

[Mikevets]

Based on COUNT(views), I will say your video is very underrated.

[Labino]

After watching over 10 videos, this video is by far the best explaining Group By. Thanks 🙏

[vinitpatidar]

Most energetic tutor I ever came across on YT. Thanks for sharing knowledge.

[mollycuka]

This is is the best video I have watched on GROUP BY. Sharing with my DBMS class :)

[dejasbeautyxoxo]

Thank you this has been BEYOND helpful. Im so happy to have found and instructor that actually explains WHY a certain action/step needs to happen in the format it does and not just the HOW. Seeing the visual of the table really helps with the comprehension.

[minimogo]

this was awesome, i was spinning in circles trying to grasp group by w/ having and this video really helped!

[jonasasare]

I can't thank you enough, this was supper helpful
Thank you

[marvinjohn]

Woah I finished a 30min video tutorial! Thanks man, this is really helpful and interesting.

[SagarKumar-dbxy]

Wow quality content. But hardly 500 views. Subbed you.

[mymusicytmsc]

I'm start to learn mysql and you help me a lot. Was wondering about count row vs count column and you have explained them very clear. Thank you.

[malwalsabino]

Thanks alot..this is clear and for the first time, I clearly understand basics of sql aggregations and having clause

[Tinypeanut]

This was a fantastic video. I learned a ton! Thank you.

[pulseandtap]

This was incredibly helpful! Thank you so much!!!

[eaglelion]

Great explaination! This helped me a lot! Thanks

[ramothkuissiTAMBO]

Cela fait des jours que je cherche un tutoriel pour comprendre cette partie et j'ai tout compris ici. Merci

[karnabudhathoki]

Thank you for sharing ur knowledge..From..🇳🇵..Nepal

[duydong]

Great video! I've seen and used things like count and group by but never understood how they really work. The examples in this video are practical and well explained! The pace was perfect. I felt like I was continuously building knowledge throughout every part of the video.

[suhaspatwa]

🎉 Very informative video, learned a lot, thanks

[gotchihaeyo]

I like the look on your face @2:10 lol
Thank you for the video!!

[praksgroc]

Where can I get the database to practice with you?