6.1 LAB - Select movie ratings with left join The Movie table has the following columns: ID - integer, primary key Title
Posted: Thu Jul 14, 2022 2:11 pm
6.1 LAB - Select movie ratings with left join
The Movie table has the following columns:
ID - integer, primary key
Title - variable-lengthstring
Genre - variable-length string
RatingCode - variable-lengthstring
Year - integer
The Rating table has the following columns:
Code - variable-length string,primary key
Description - variable-lengthstring
Write a SELECT statement to select the Title, Year, and ratingDescription. Display all movies, whether or not a RatingCode isavailable.
Hint: Perform a LEFT JOIN on the Movie and Rating tables,matching the RatingCode and Code columns.
The Movie table has the following columns:
ID - integer, primary key
Title - variable-lengthstring
Genre - variable-length string
RatingCode - variable-lengthstring
Year - integer
The Rating table has the following columns:
Code - variable-length string,primary key
Description - variable-lengthstring
Write a SELECT statement to select the Title, Year, and ratingDescription. Display all movies, whether or not a RatingCode isavailable.
Hint: Perform a LEFT JOIN on the Movie and Rating tables,matching the RatingCode and Code columns.