Datasets Movies dataset

Movies dataset

The Movies dataset contains data from some of the best films released since the 1990s.

It includes information on actors, directors, and key movie statistics like budget and revenue. The most interesting part is probably the ratings table. Please note that the ratings were artificially generated, so the final movie scores only partially correlate with real IMDb data.

Enjoy the show!

Practice exercises

1. Most Prolific Directors

Start
2. Movies starring specific actor

Start
3. Time gaps between movies

Start
4. Most popular genre by decade

Start
5. Movies with the longest runtime

Start
6. Genre distribution of ratings

Start
7. Movie franchises

Start
8. Most recent movie by director

Start
9. Popular movies released in the same month

Start
10. Directors’ movie revenue share

Start
11. The longest movie franchise

Start
12. Most prolific actors

Start
13. TOP-5 movie genres

Start
14. Highest rated directors

Start
15. Highest Grossing Movies

Start
16. Actor collaborations

Start
17. Director’s biggest hits

Start
18. Movies with above average revenue

Start
19. Average movie duration by genre

Start
20. Most versatile actors

Start
21. Average movie rating by year

Start
22. Actors with consecutive high ratings

Start
23. Top rated movies

Start

Movies dataset

Practice exercises

Fluent in SQL in a month