Navigate Select ESC Close

Subqueries in MySQL | Intermediate MySQL

2024-02-20 Education
183.4k
2.9k
111
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 Subqueries in MySQL! GitHub Code: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Intermediate%20-%20Subqueries.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)

@Gigglygoo-p9g 2025-06-30

i finally understand, the easier steps is you need to perform the subquery first and then you can do the main query, its so much easier to understand

12
@delhiwala8511 2024-02-20

Hello Sir Ji Love You Hogaya From India 🇮🇳

13
@SophieAbrams-e3b 2024-10-08

Definitely the first video I started having some difficulty fully understanding. Any other resources you suggest looking at?

78 5 replies
@ATCSABChaitra 2024-02-20

U are the best mentor and guide

13
@irdcs 2024-07-12

Honestly it was too confusing to me (I'm starting from scratch) so I'm gonna have to learn this somewhere before I continue with the course. So frustrating 😅.

11
@auroratinuviel 2025-04-22

I had a hard time understanding this one, so I asked AI and this is the answer: “Find me all customers who have placed more than 5 orders.” You could first pull “all customers’ order‐counts” (that’s your subquery), then ask “give me those over 5” (the outer query)." It helped me so I am leaving it here for someone who needs it!

37 1 replies
@Princepapii 2025-05-25

First lesson I'm having a little difficulty with. Definitely will have to comeback to this. Its like i kinda get it but don't. I think practicing for another day will get me right.

5
@jyg9504 2025-10-09

Had an easier time understanding it due to a rewatch and helpful comments. Subqueries are actually dope.

1
@omarp2010 2026-01-15

I am doing this to keep myself accountable. Completed this on 1/14/2026 @ 6:26pm

6 3 replies
@pellelhn1460 2025-07-16

I started watching this series and it helped me learning mysql. Definitely a good tutorial series. Thank you. MySQL is good for many things.

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