Subqueries in MySQL | Intermediate MySQL

In this lesson we are going to take a look at Subqueries 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*

[auroratinuviel]

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!

[SophieAbrams-eb]

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

[BruceBeck-fn]

A LOT going on in this lesson. Alex did a nice job of walking me through subqueries in MySQL. As the previous commenter suggests, I need MORE practice to really get these concepts embedded into the "gray matter" inside my head. At the very least, I intend to re-watch this video a couple of times without trying to keep up typing code, etc. I am getting a great deal of value from all of Alex's work. Thanks! 😎

[brazehvic]

Great explanations and options. Would have been better if you included the data file link to self-practice. Remember the best way to learn is learning by doing!

[Thisisrealfia]

Just when I needed to understand more about 'subqueries', this video came up. Thanks, Alex!

[WilnerSumagingsing]

Subquery can be denote as a virtual table. It can be use also with JOIN clause. Thanks

[muhammadintesar]

Subqueries squeses my mind hard but by going through again and again and got every point it was a complex concept but well taught by the Legend ALEX

[delhiwala]

Hello Sir Ji Love You Hogaya From India 🇮🇳

[irdcs]

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

[saimunalam]

I was constantly getting avg('max(age) = 0 for both male and female. And then realized @8:45 ... I was using single quote marks instead of THIS ``

[danbeat]

💥💫Hello sir, you're the best💯
From GABON

[colleenoleary]

At 2: 35, when you get the results of the subquery...I'm not. I'm getting the results of the full query b/c I've been hitting the bolt w/ the I on it, instead of the bolt by itself...which is what you're doing in the video, but not mentioning which bolt you're hitting and why.

Please specify which one you're hitting to get the results you're getting.

Also, I don't understand WHY you would do what you did from 8:00 on.
What's the use case for it?

[kushalsaha]

Timestamp- 3:02

What if I want to see the salary also with these other informations? I can't return more than 1 column in operand. So how to find salary?

[atzirimendozagtz]

I don't know if I missed it but does where you insert the subquery make a difference? If so, what are they so that I can better understand when I run into the need to use a subquery.

[FirasIsleem-qcis]

I have question is that oky to start studying mysql then sql, or does that make the process easy to grasp

[PrithaMajumder]

Sir, Thanks a lot for This Amazing Lecture 😊
Lecture - 5 Completed ✅ in Intermediate MySQL 🛢

[mamoudshahin]

Just came from the google data analytics lesson. The Coursera video, unfortunately, was not clear enough on subqueries ... This video is much clearer .. Thank you Alex, I knew I would find the clarification here.

[sillygoose]

ALEX!!! Awesome guide!! This video is very easy to understand for beginners which i appreciate. Just a quick question on the aggregate function AVG in the subquiery, Why doesn't it require a GROUP BY statement?

[sadooya]

can someone explain me why exactly do we need to add the multiple Tabs before adding the another query 1:50

[VkTolani]

we can use 3:50 self join here as well?