We Learn SQL #9 | Simple subqueries in SQL

A subquery is a SQL query nested inside a larger query. They are extremely useful, thanks to which your code will be easier to read, simpler, so you will work much faster and more efficiently.
If you want to learn or practice SQL, check out learnsql.com/.
Hello, my name is Adrian, and this is a series of videos devoted to the basics of SQL. This time, we’re going to give you an introduction to SQL subqueries, a very powerful tool when creating SQL queries.
Let’s learn SQL together!
👌 Subscribe to our channel and leave a comment!
👌 Do you want to learn SQL? Go to LearnSQL.com and choose the course or track that is best for you!
👌 Join us on Facebook: / welearnsql
🔊 Music: www.bensound.com/

[@siddhantfursule829]

Awesome explanation, I coudn't understand subqueries in a website that i joined. So, I came to youtube, thinking that I can clear my doubt here. I was three videos in and I still didn't understand. Finally as my last hope, I thought to click on this video and now I understand what subqueries exactly do. Thank you!

[@DavidaThatch]

This was wonderfully explained, thank you!

[@smashingtennis]

Great explanation - I just did a paid course looking at this topic and your explanation was much better. It makes much more sense to say that you can evaluate the query to return a single value, and then input that subquery (which returns the result) into another - just like composition of functions in programming (or math). I am going to watch all your videos now.

[@TheDiscretion2011]

Awesome awesome awesome explanation! This was the video that made sub queries start to make sense to me. Thank you!

[@DonAusby]

Wow. Great explanation! Thank you for explaining complex subjects in a reductive way that makes it easier to understand!

[@keifer7813]

Nice, quick, and simple. Thank you

[@basiabbas6537]

Thank you for the really good explanation!!!

[@shreyashachoudhary480]

Great playlist

[@phiphongnguyen3352]

thanks you very much

[@suyashsrivastava3671]

Thanks Nicely explained !!! Is it same way in mysql?

[@clarosantiago2601]

What’s the impact pf subqueries in terms of speed in getting high number of rows?

[@Trazynn]

Content is great, but the music is quite loud.

[@sarv-shreshth]

Good job

[@naomirono8326]

Kindly help me understand what data types did you use

[@pavlerakic3951]

Is "where rating > AVG(rating)" wrong?

[@RishiRap]

omg...why the heck do you have to add background music? We need to listen to your content and not the music. Such a distraction. drives me crazy.