Group By + Order By in MySQL | Beginner MySQL Series

In this lesson we are going to take a look at Group By and Order By in MySQL!

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[elizabeth]

I love this tutorial, crystal clear, useful examples, straight to the point!

[vinodkumar-tjtc]

- [00:00] 📊 Group By in MySQL groups rows with the same values in specified columns and allows running aggregate functions on them.
- [02:13] 📈 Aggregate functions like AVG, MAX, MIN, and COUNT can be used with Group By to calculate statistics for grouped rows.
- [05:51] 🔄 Order By sorts the result set in ascending or descending order based on specified columns.
- [07:40] 🎯 Multiple columns can be used for sorting with Order By, allowing hierarchical sorting based on specified column order.
- [09:04] ⚠ Using column positions instead of names in Order By is possible but not recommended due to potential issues with column changes.

[learningeveryday]

Alex I can tell is 'too kool' especially from hearing the genre he has for his channel! I just earned my Google Analytics certificate and am diving into data analytics. Big thanks to Alex for everything he’s doing—a truly intelligent individual. God bless you in everything you do!

[BruceBeck-fn]

Alex, this series on MySQL is really polished, no hiccups at all. Also appreciate your GitHub repository where I can also follow along with your SQL files. It's great to see SQL syntax that just works the way it is supposed to. I also appreciate the occasional "best practice" you share (i.e. Normally using proper column names in the GROUP BY clause vice column numbers, etc.) Working smart, not hard ALWAYS appeals to my brain. Thanks again for the awesome content! 😉

[ayodeleoluwatosin]

I am starting my data analysis learning today and I will come back to give some progress report later.

[inq_]

Thank you Alex.
I Just started learning data analytics with your bootcamp playlist and currently I am a little bit confused whether I continue learning the SQL part or jump to excel part and at the same time keep following this MySQL serie. I'm thinking about doing it all because I'm still a rookie and I have to learn.
I will be happy to hear your suggestion.
And thank you once again Alex for you content.

[Lceeh]

Thanks Alex for all your hard work! This tutorial was very easy to follow and understand. I appreciate you going over the small simple details within the function.

[gloration]

The group by clause finally makes sense! Thank you so much for this tutorial and also for switching to MySQL 👏🏻

[azizqady]

The lesson is about:
1. The use of "Group By" and "Order By"
2. The use of AVG(), MIN(), MAX(), COUNT()

[ashtonwilson]

This was very helpful! Thank you so much!

[uwayojacques]

thanks Alex for the good tutorial . where can we get the csv data you have used ?

[mozammilalam]

Alex, hello! 🚀 I wanted to be the first to comment and say how much I appreciate all of the amazing content you make! 🙌 Your ability to analyze things is impressive. I would adore the chance to collaborate with you and add to your wonderful projects. I am sure that I can contribute useful expertise. Just a quick intro about me, I am an analyst with almost 3 year of experience Let's talk about how I can benefit the team as a new member! 🌼 #TeamAlex

[Jessie-ctqq]

Hi Alex, Thank you for this awesome video. Can we add this project in resume? if yes, how can we add. Please help me.

[chukwuezeprince]

please I'm having issues with my query ...i did exactly like u did in the video 1:09 where my SELECT clause was gender and my GROUP BY was also gender but the synatx is saying error in mysql

[tresconik]

Is there a place with practice questions related to this concept?

[JJCage]

@3:15 You select from employee_salary and group by gender. employee_salary does not have a gender column. I could not get it to work due to the group by request. I also used the select * as you did. The select * would only apply to the employee_salary and not the entire DB since you specified from that table.

[elizabeth]

Also there doesn't seem to be a way to purchase 1 course at one time, it appears that we have to choose a bundle

[badrgamel]

can someone help me with the order thing because i didn't get it because i didn't get what is the diffrance between gender, age and age, gender thing he did

[ibrahimbandaogo]

I am having problems accessing the downloaded SQL for my practice

[duurduranto]

loving the lessons. Waiting for the rest.