Exercise

Counting missing rows with left join

The Movie Database is supported by volunteers going out into the world, collecting data, and entering it into the database. This includes financial data, such as movie budget and revenue. If you wanted to know which movies are still missing data, you could use a left join to identify them. Practice using a left join by merging the movies table and the financials table.

The movies and financials tables have been loaded for you.

Instructions 1/3

undefined XP

1
2
3

Question

What column is likely the best column to merge the two tables on?

Possible Answers

on='budget'
on='popularity'
on='id'