We Learn SQL #14 | Correlated subqueries with EXISTS in SQL

We’re going to talk about a new SQL operator named EXISTS, and how we can use it along with correlated subqueries.
If you want to learn or practice SQL, check out learnsql.com/.
Hello, I’m Adrian and this is another video in the series about SQL basics. You already know quite a lot about subqueries in SQL. In the previous video, we introduced correlated subqueries. Expand your arsenal with another SQL operator - EXISTS. Learn how to use them effectively and how to write better and clearer SQL queries.
Regardless of whether you are just starting your adventure with SQL or you are already an advanced user - I recommend our We Learn SQL channel and my short clips on the basics of SQL. I have recorded episodes about SQL JOINs, SQL Group by clause, and many more. Watch them and give them a thumbs up.
👌 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/

[@stri06]

the information is clear but please do not ad music it's very distracting

[@shaistachattha8508]

I find your teaching method very helpful but the music keeps distracting me. Can you please remove the background music? Or at the least keep it very low.

[@ajithshenoy5566]

the music is so annoying

[@ank18]

I like your videos. They are easy to understand but can you please get rid of the background music. it suppresses what you are saying in the video.

[@Sumfinfunny777]

great video. Maybe lower the music volume a tad little? Just a suggestion

[@mn2410]

Thanks for the video. Could you please remove the background music and speak a bit louder.

[@TheProblembaer2]

Hey Content creator, your videos are really great, and thank you. But please, coulde you reupload without music, it distracts me alottt!

[@anvarichn]

Writing this comment to complaint on too loud music - Hopefully that can be fixed!

[@bigbeast007]

Think the output shown in video for "WHERE NOT EXISTS" is incorrect. It should fetch 2 values instead of 1. It should be "Magical Products" and "Amazing Stuff" as both of them have items less than 1 $

[@WindzGamingYT]

You may have misheard the question, which was to find the suppliers that “do not provide ANY products more expensive than a dollar”
“Amazing Stuff”, has a product called “Chewing Gum” that costs more than a dollar

[@shivamshekhar8027]

Stumbled upon your Channel today, and I gotta tell these are the simplest SQL videos out here.
Waiting for more stuff!

[@faisalabdo4600]

the music dude !!!!!

[@awilson1989]

sound is too low, can't hear you even on %100 :/

[@hendrag1174]

Thank you very much Adrian for this great video which I think the best video regarding the Exists clause.

[@scottyblesthunter5118]

the background music is so distracting

[@labibalmahdi1393]

The background music is badly distracting

[@MagnusAnand]

Quick and to the point !

[@stickercode]

I couldn't still get it. So , what is the real function of this exists though? If we, let's say remove it from your query sample, what will be fundamentally changed in the result set?

[@fromtonghua5018]

I like the small table examples.

[@laszlogergelykiss3921]

Music is bothering...

[@martajumi.inranbows3285]

świetne materiały, Adrian :)!

[@Jimmy_Neutron]

Raise the music so we can’t hear you ❤

[@sogolsaremi6306]

Great Videos!

[@dimasfariznugroho583]

please dont stop sharing :)
and also we need indonesian translate language :(

[@shreyashachoudhary480]

SQL++