From the course: SQL: Data Reporting and Analysis

Unlock the full course today

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

Challenge: Join tables

Challenge: Join tables - SQL Tutorial

From the course: SQL: Data Reporting and Analysis

Start my 1-month free trial Buy for my team

Challenge: Join tables

“

(upbeat music) - [Instructor] Conceptually, this challenge is very simple. You want to return all data from the film, film_category, and category tables, filtering for comedies. Last time we filtered for a film type in a challenge, we used the like keyword and the description field from the film table to filter for drama types. But that was a bit of a hack, really. The category table is what stores actual film type. You can see we have action, animation, and then number five there is comedy, and this is what we're going to filter on. So this challenge is all about joining tables together in order to perform a proper filter. In query terms, we want to return all records from the film, film_category and category tables, filtering on category.name = "comedy". You should be able to complete this in five minutes.

Contents