From the course: Intermediate SQL: Data Reporting and Analysis

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Challenge: Update the film table using JOIN

Challenge: Update the film table using JOIN - SQL Tutorial

From the course: Intermediate SQL: Data Reporting and Analysis

Start my 1-month free trial Buy for my team

Challenge: Update the film table using JOIN

“

(upbeat music) - [Instructor] Let's say that you've noticed the release year column in the film table is wrong. It should contain the year from the last update column of the film category table. To fix this mistake, you need to set the release year column from the film table to be the year of the last update column in the film category table. This is your challenge and it will require two things. You will need to join two tables together and you will need to use a function in your query because release year and last update have different data types. Five minutes should be enough for this query. Good luck.

Contents