Refer to the exhibit. A data analyst writes a SQL query to extract information from multiple tables in the Movies database. To complete the ON command, what needs to be entered in place of the question mark in this query?
SELECT m.Title, m.Date, r.AuthorName, r.Score, r.Comment, r.Date
FROM Review AS r
JOIN Movie AS m
ON m.Title = ?;
- r.Date;
- r.Comment;
- r.MovieTitle;
- r.ID;
- r.Score;
Explanation & Hint: To combine two tables, a SQL JOIN can use columns containing the same data type and information in both tables. The Title column in the Movie table includes the movie’s name, and the MovieTitle column in the Review table contains the same information. Even though the Date column appears in both tables, it does not have the same information and, therefore, cannot be used in the JOIN.