DAT/380 Week 2 LAB 2.9 – Select movie ratings with left join

$ 5

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.

997 in stock

SKU: DAT380WK2L2P9 Category:

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.

Only logged in customers who have purchased this product may leave a review.