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)