Details
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.
Additional Information
| Special Price | $3.00 |
|---|
Check items to add to the cart or select all
-
DAT/380 Week 2 LAB 2.10 - Select employees and managers with inner join
Add to WishlistRegular Price:
Special Price
You have no items in your shopping cart.
