Navigate Select ESC Close

Group By + Order By in MySQL | Beginner MySQL Series

2023-11-28 Education
303.8k
5.1k
116
Alex The Analyst
Alex The Analyst
1.4m subscribers

Unlock all features

FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.

Description

Full MySQL Course: https://www.analystbuilder.com/courses/mysql-for-data-analytics In this lesson we are going to take a look at Group By and Order By in MySQL! GitHub Code: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Beginner%20-%20Group%20By%20%2B%20Order%20By.sql ____________________________________________ 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: 📖Google Data Analyst Certification: https://coursera.pxf.io/5bBd62 📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy 📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR 📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: 📖Python for Data Science - https://bit.ly/3Z4A5K6 📖Statistics for Data Science - https://bit.ly/37jqDbq 📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij 📖Tableau A-Z - http://bit.ly/385lYvN *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! https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join ____________________________________________ Websites: 💻Website: AlexTheAnalyst.com 💾GitHub: https://github.com/AlexTheAnalyst 📱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*

Top Comments (10)

@vinodkumar-07-65 2024-05-25

- [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.

125
@elizabeth00653 2024-01-19

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

51
@azizqady243 2024-07-05

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

41
@BurgerWithCheez 2026-05-23

Starting my journey to a data analyst at 11 years old!

8
@learningeveryday3057 2024-10-03

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!

6 4 replies
@YaraMohamed-s5p 2025-02-22

I am from Germany and I Find your videos very interesting and helpful, I can understand everything you say,thank you so much

3
@Venkat-q8d1y 2025-08-11

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

3
@T.B.Y. 2024-11-13

GROUP BY has been a head scratcher up until now... Thank you Alex!

2
@berhannegewo2950 2026-05-09

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.

1
@Fusion213 2024-12-04

I love how he gets to the point and doing it so clearly

0

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

App screenshot