How to use the SQL EXISTS and NOT EXISTS conditional operators

In this video, we are going to see how the SQL EXISTS and NOT EXISTS operators work and when you should use them.
Although these operators have been available since SQL:86, the very first edition of the SQL Standard, I found that there are still many application developers who don’t realize how powerful SQL subquery expressions really are when it comes to filtering a given table based on a condition evaluated on a different table.
This video is just a sample of my High-Performance SQL video course.
vladmihalcea.com/courses/high...

[@nastygambler2522]

The legend is HERE.. Thank You for the video legend !!

[@vladmihalcea]

You're welcome and stay tuned for more

[@ConiCalaro]

Awesome video and direct explanation, thanks from Brazil

[@vladmihalcea]

Thanks. I'm glad you liked it. This is part of my High-Performace SQL video course, so if you liked it, you are going to love the entire course.
vladmihalcea.com/courses/high-performance-sql/

[@hadiahmadzadeh4235]

Great explanation! Thank you

[@vladmihalcea]

Thanks and stay tuned for more

[@teddyfabriciocordovasaenz3018]

Great explanation Sir.

[@vladmihalcea]

You're welcome. If you liked this episode, you are going to love my High-Performance SQL video course.

[@ImMouldyJim]

Thanks!

[@vladmihalcea]

You're welcome

[@gudguy1a]

Good job, thanks for posting to clarify it better for us.
But,
if you don't mind, this is for 10th grade delineation.
And not having a grade score of 10 (and if you meant 10th grade, apologies in advance).
Never mind, I see later on that you 'are' talking grades of 10, 9, 8, etc...

[@vladmihalcea]

In Europe, where I live, many countries use the 0-10 grade system, where 10 is the highest score.
www.nuffic.nl/en/education-systems/european-baccalaureate/grades-and-study-results
Hence, the example in this video.