SQL Project –

Source of Dataset: Unknown (data included up to 2020)

Data sets:

Project: Determine the country and category for a new show.

We are brainstorming ideas for new shows and want to know what country and category account for the most shows in our current library. What country and category account is ideal for a new show?

Generate a list of the current categories for all shows:

SELECT DISTINCT listed_in

FROM mynetflix-415823.mynetflix.categories

ORDER BY listed_in;

Generate a list of individual countries where current shows have been developed:

SELECT DISTINCT

  country

FROM mynetflix-415823.mynetflix.countries

ORDER BY country;

What countries have our shows come from and in what categories they are in?

SELECT co.country,

  CAT.listed_in,  

  COUNT(TI.title) AS Num_of_titles

FROM mynetflix-415823.mynetflix.categories as CAT

JOIN mynetflix-415823.mynetflix.titles AS TI ON

CAT.show_id = TI.show_id

JOIN mynetflix-415823.mynetflix.countries CO ON

  CO.show_id = TI.show_id

GROUP BY

CO..country,

CAT.listed_in

ORDER BY Num_of_Titles DESC;

Release Dates by Country:

SELECT

  c.country,

  min(d.release_year),

  max(d.release_year)

FROM mynetflix-415823.mynetflix.countries as c

JOIN mynetflix-415823.mynetflix.details as d

  ON c.show_id = d.show_id

GROUP BY

  c.country

ORDER BY

  c.country;

Analysis

A dashboard was created in PowerBI to ease filtering the data by country and category utilizing a column chart, a bar chart, slicers, and a data card.

In analyzing the country data, the United States surpasses any other country by more than double with 4,745 shows .

This is due in part because the United States is the origin of movies and shows going back to 1942. The runner-up is India with 2,246 titles

.We see that in the United States, the most popular of the shows on Netflix are Dramas (533). This is interesting because according to The Numbers (2025), Business report, Drama has been a volatile category, decreasing since 2000. It shows that Action movies experienced an exponential bump between 2000 and 2024, peaking in 2022 – 2023 holding over 50% of market share. However, since then there has been a sharp decline to less then 25% of market share. It’s worth noting that the International category is not included in their data and Drama shows as the third highest category.

(Graph: The Numbers, 2025)

Because Netflix utilizes a highly accurate algorithm to recommend tv shows and movies based on the users’ viewing behavior (Sheynin, 2024). It can be surmised that due to the accurate nature of Netflix’s recommendations, this dataset from Netflix would supersede the general data from The Numbers, 2024.

Whether Netflix is an anomaly or not remains to be seen, but the numbers are derived from their library through 2020 and supported by their successful algorithms. Netflix has had tremendous success with this library. and recommendations. Accolades include 23 Oscars in 13 categories, not including the 150 nominations received for original movies in 2025 (Saab, et al., 2025).

Another top performer in the Netflix library is India with a significant amount of international shows.

It is evident that for the Netflix streaming platform, the most likely success would come from the Drama genre in the United States based on the data from the Netflix dataset.