2.9 LAB - Select movie ratings with left join - The Movie table has the following columns: . • ID - integer, primary key
Posted: Mon May 09, 2022 7:11 am
- 2 9 Lab Select Movie Ratings With Left Join The Movie Table Has The Following Columns Id Integer Primary Key 1 (116.74 KiB) Viewed 293 times
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. 404418.1909202.qx3zqy7