Subqueries in MySQL | Intermediate MySQL

U are the best mentor and guide

Great!!!

Hello Sir Ji Love You Hogaya From India 🇮🇳

I am currently learning sql and I am watching your videos especially the bootcamp ones. I already finished the videos for sql, is there any platform/s you can recommend to practice what I learned from the videos? I am kind of lost on how to practice these learnings. Thank you!

Loving this series ! Thanks so much

Great guy

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!

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

Thanks alex for the easy explanation.. just a question, when you wanted to compare the salaries to avg salary, we also can use Partition by instead of s subquery right?

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! 😎

Hiii im getting zero in subquries

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.

Thank you so much :D

select salary,(select avg(salary) from employee_salary
) avgSalary,
case
when salary>avgSalary then 'This employee is earning good'
end as label
from employee_salary ;


when executing this code it says there is no column as avgSalary while I renamed the output coming from subquery as avgSalary, can we not use alias while comparing it with original column?

Hello Alex I couldn't download my SQL anyone help me please

Lord, subqueries was tough grasp

Thank you sir 💟

You are a great tutor

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

CTEs are so much more straightforward.

please provide dataset it really helps to practice

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?

What is the purpose of the later half of the subquery?

where can i practice SQL section wise?

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

I don't understand why we haven't used bonus condition in same case statement

I have a question, is it not better to use JOINS instead of subqueries?. From what I understand so far.

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

Excellent explanation, thanks

Thank you.

thankyou for the video!

Such lucid explanation gives me confidence to become successful data analyst, May our Good Lord Sheperd bless you with good health, wealth and eternal happiness! ✝

I'm having trouble understanding this one.
"WHERE dept_id = 1"
Why does it return 1,3,4,5,6,12 ?
TIA

✅

i fried my brain trying to do subquery within subquery within a query but i managed to do it in the end🤓🤕

Why could you not have been my teacher in uni huh?

Thank you Alex!

Hi Alex - sorry for a silly question but mayby because I am coming from a different language but the concept AVG(max_age) - what kind of average is it ? Max age is a max age - trying to uderstand what average is in that - life expectancy?

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

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.