We Learn SQL #9 | Simple subqueries in SQL

[@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!

[@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.

[@DonAusby]

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

[@TheDiscretion2011]

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

[@DavidaThatch]

This was wonderfully explained, thank you!

[@Trazynn]

Content is great, but the music is quite loud.

[@keifer7813]

Nice, quick, and simple. Thank you

[@basiabbas6537]

Thank you for the really good explanation!!!

[@shreyashachoudhary480]

Great playlist

[@phiphongnguyen3352]

thanks you very much

[@naomirono8326]

Kindly help me understand what data types did you use

[@sarv-shreshth]

Good job

[@clarosantiago2601]

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

[@suyashsrivastava3671]

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

[@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.

[@pavlerakic3951]

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