Practice Most popular genre by decade

Most popular genre by decade

Difficulty 🌶 🌶 🌶 🌶

About the exercise

Find the most popular genre for each decade based on the number of movies produced.

đź’ľ  About the 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! 🎥

Anatoli Makarevich, author of SQL Habit About SQL Habit

Hi, it’s Anatoli, the author of SQL Habit. 👋

SQL Habit is a course (or, as some of the students say, “business simulator”). It’s based on a story of a fictional startup called Bindle. You’ll play a role of their Data Analyst 📊 and solve real-life challenges from Business, Marketing, and Product Management.

SQL Habit is also a collection of Practice exercises (you’re looking at one atm) based on various datasets (E-commerce, Finance, etc). They’re meant to deepen your SQL and Data Analysis knowledge 💪, prepare you for any challenge at work or a job interview.

“well worth the money”

Fluent in SQL in a month

Master Data Analysis with SQL with real life examples from Product Management, Marketing, Finance and more.