Skip to content
This repository has been archived by the owner on Feb 20, 2023. It is now read-only.

Latest commit

 

History

History
31 lines (16 loc) · 1.55 KB

Puzzles.md

File metadata and controls

31 lines (16 loc) · 1.55 KB

Puzzles

Start Exploring at the IMDB:Title Explorer and see if you can answer the following questions.

Puzzles to learn about what's in the database.

  • What is the count of titles in the database?

  • Titles always have a production year. Are the number of titles produced each year going up or down?

  • What are all the possible kinds of titles in the database?

  • Titles can have multiple genres. What is the most common genre amongst the movies in the database? (Hint: you will have to set a filter on kind of title)

  • Which genre of movie has made the most money in total revenue?

  • Which Production Company has made the most TV Episodes?

  • What Person has appeared in the most TV Episodes?

  • What TV Series Title has the most TV Episodes;

  • A TV Episode is a kind of title (so all the title fields work). What TV Series Title is the longest running measured in Production Year Count? BONUS: What Year was it first produced?

  • What Person has appeared most often on the TV Series Titled 'Late Show with David Letterman? (Hint: even a guest is a Cast Member with the Role/Job Actor)

More Advanced Puzzles

  • What two genres most co-occur? (Hint: you can add by more than one genre by clicking on Also in Title)

  • What titles have had a creation location in Santa Cruz, California? (Hint: you may have to use a contains filter on a location. You may have to set another filter too, because there is a Santa Cruz in Mexico).