(Solved): 2.9 LAB - Select movie ratings with left join The Movie table has the following columns: - ID - in ...

2.9 LAB - Select movie ratings with left join The Movie table has the following columns: - ID - integer, primary key - Title - variable-length string - Genre - variable-length string - RatingCode - variable-length string - Year-integer The Rating table has the following columns: - Code - variable-length string, primary key - Description - variable-length string Write a SELECT statement to select the Title, Year, and rating Description. Display all movies, whether or not a RatingCode is available. Hint: Perform a LEFT JOIN on the Movie and Rating tables, matching the RatingCode and Code columns. \( 424546.1975144 .9 \times 3 z q y 7 \)