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/
Thank you so much for the video, the editing and everything is very good for explaining queries! I finally think I can do my homework haha. I am unsure why we can't just use SELECT to get Alice with a grade of 10 rather than EXISTS.
I'm not sure but there is no student name column in the student_grades table but we have the ID. we use EXISTS because we don't want to join the 2 tables, otherwise you can use SELECT.
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...
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.
The legend is HERE.. Thank You for the video legend !!
You're welcome and stay tuned for more
Awesome video and direct explanation, thanks from Brazil
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/
Great explanation Sir.
You're welcome. If you liked this episode, you are going to love my High-Performance SQL video course.
Thank you so much for the video, the editing and everything is very good for explaining queries! I finally think I can do my homework haha.
I am unsure why we can't just use SELECT to get Alice with a grade of 10 rather than EXISTS.
I'm not sure but there is no student name column in the student_grades table but we have the ID. we use EXISTS because we don't want to join the 2 tables, otherwise you can use SELECT.
Great explanation! Thank you
Thanks and stay tuned for more
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...
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.
Thanks!
You're welcome