Subqueries in MySQL | Intermediate MySQL

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Subqueries in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
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: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - 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!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: 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

[@ATCSABChaitra]

U are the best mentor and guide

[@user-kq3tc5tu1c]

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

[@RubaShu]

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?

[@brazehvic8896]

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!

[@bjrnolavskaurum3854]

True. Having the dataset to work on would be way better than watching someone else perform tasks. Hopefully Alex reads your comment.

[@aditya.dhankhar]

You can find the data files in the first video of the beginner MySQL series on Alex's channel.

[@cjbrown3396]

You have to follow his course along the way. Alex used the file in the beginning as the teaching series.

[@atzirimendozagtz9787]

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.

[@nickl3135]

Loving this series ! Thanks so much

[@rajkumarrajan8059]

Great!!!

[@emmanuelamukamara4931]

Great guy

[@yeniramirez911]

Thank you so much :D

[@Thisisrealfia]

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

[@chubz155]

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!

[@rukayatogundipe5779]

You can practice on analyst builder or hackerrank

[@chubz155]

Thank you very much @@rukayatogundipe5779

[@sujansapkota0504]

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?

[@delhiwala8511]

Hello Sir Ji Love You Hogaya From India 🇮🇳

[@GHOST-17.]

Microsoft SQL server and my SQL same or what plz reply sir ???

[@katrinanorahnabunjo6988]

They are both Relational Database Managers but they are not the same. One is made by Microsoft and the other (MySQL) is open source.

[@pamelamills8463]

Great video; I like how you take the time to inform your audience. Everyone wants to live a better life and be financially stable. By making the appropriate investments, living simply, and creating a budget, this is simple to do. Early in life, I discovered that hard effort is the path to financial independence.

[@karimullasyed3695]

Hiii im getting zero in subquries

[@karimullasyed3695]

Alex please respond

[@karimullasyed3695]

9.14 sec the answer which was getting for you not getting same output for me i have type same thing what ew have teach in this video please guide me alex