Posted on:

05 Jun 2023

0

Course Exam : Question 8 & 9

Dear 365datascience team,
For question 8, I find it hard to figure out how come the place of "where" condition would make such a difference?
Since we're all using "INNER JOIN" in this case, the condition should been applied to all the result set as well, regardless of placing it in the subquery or not, right? I would need your further explanation in detail to this question.
For question 9, after type in the code and get the result, I find out that the choice between a (g.genre_id, a.genre_id, s.genre_id) would make no differences to the result, but the (s.release_date & a.release_date).
Thank you!

0 answers ( 0 marked as helpful)

Submit an answer