Group By + Order By in MySQL | Beginner MySQL Series
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Unlock all features
FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.
Related videos
Learn Databricks in Under 2 Hours
Alex The Analyst
76.7k views
How to Become a Healthcare Analyst in 2025
Alex The Analyst
44.7k views
Learn SQL Beginner to Advanced in Under 4 Hours
Alex The Analyst
1.3m views
MySQL Exploratory Data Analysis | Full Project
Alex The Analyst
169.7k views
Data Cleaning in MySQL | Full Project
Alex The Analyst
422.7k views
Triggers and Events in MySQL | Advanced MySQL Series
Alex The Analyst
156.7k views
Stored Procedures in MySQL | Advanced MySQL Series
Alex The Analyst
166.4k views
CTEs in MySQL | Advanced MySQL Series
Alex The Analyst
188.0k views
Window Functions in MySQL | Intermediate MySQL
Alex The Analyst
222.0k views
Subqueries in MySQL | Intermediate MySQL
Alex The Analyst
183.4k views
Top Comments (10)
- [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.
I love this tutorial, crystal clear, useful examples, straight to the point!
The lesson is about: 1. The use of "Group By" and "Order By" 2. The use of AVG(), MIN(), MAX(), COUNT()
Starting my journey to a data analyst at 11 years old!
Alex I can tell is 'too kool' especially from hearing the genre of music 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!
I am from Germany and I Find your videos very interesting and helpful, I can understand everything you say,thank you so much
Thanks for sharing Free Data Analyst Bootcamp, having zero knowledge or background , but challenged myself to upgrade skills. Done 6 / 84 .. Group by, Max (), Min(), AVG(), Order by, ascending and descending order
GROUP BY has been a head scratcher up until now... Thank you Alex!
GROUP BY is used to combine rows that have the same values into summary rows, usually with aggregate functions like COUNT(), SUM(), AVG(), MIN(), and MAX(). ORDER BY is used to sort the result set in ascending or descending order.
I love how he gets to the point and doing it so clearly
Unlock the Data Inside
Turn Videos into Knowledge
- Get FREE 10/day: transcripts, summaries, chats
- Chat with videos, export text & PDF
- $1 free API credit for RAG, chatbots & research
Free forever plan • All features unlocked
Top Comments (10)
- [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.
I love this tutorial, crystal clear, useful examples, straight to the point!
The lesson is about: 1. The use of "Group By" and "Order By" 2. The use of AVG(), MIN(), MAX(), COUNT()
Starting my journey to a data analyst at 11 years old!
Alex I can tell is 'too kool' especially from hearing the genre of music 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!
I am from Germany and I Find your videos very interesting and helpful, I can understand everything you say,thank you so much
Thanks for sharing Free Data Analyst Bootcamp, having zero knowledge or background , but challenged myself to upgrade skills. Done 6 / 84 .. Group by, Max (), Min(), AVG(), Order by, ascending and descending order
GROUP BY has been a head scratcher up until now... Thank you Alex!
GROUP BY is used to combine rows that have the same values into summary rows, usually with aggregate functions like COUNT(), SUM(), AVG(), MIN(), and MAX(). ORDER BY is used to sort the result set in ascending or descending order.
I love how he gets to the point and doing it so clearly