Перейти к содержимому

Learn SQL in 14 Days | Day 8: GROUP BY and HAVING

Dr. Ley Sylvester

0:00 / 0:00

Learn SQL in 14 Days | Day 8: GROUP BY and HAVING

53 просмотра · 3 дн. назад
Dr. Ley Sylvester
65 подписчиков
53 просмотра · 3 дн. назад
Welcome to Day 8 of Learn SQL in 14 Days! In this lesson, you'll build on the aggregate functions covered in Day 7 by learning how to use GROUP BY and HAVING to summarize and filter grouped data. We'll explore how to organize records into groups, calculate totals and averages for each group, and use HAVING to filter results based on aggregate values. You'll also learn the difference between WHERE and HAVING and when to use each one. *Before You Begin* If you haven't completed Days 1–7, I recommend watching those lessons first, especially Day 7 on aggregate functions. We're using the same sample database throughout all 14 days, so there's no need to set it up again. If you're joining the series at Day 8, you can find the database setup instructions and practice files here: https://github.com/leysylvester-demo/... *More SQL learning resources:* https://taleylearn.com/ #LearnSQL #SQLForBeginners #SQLTutorial