Description
DAT/380 Week 2 LAB 2.9 – 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.
Reviews
There are no reviews yet.