NETFLIX SQL
PROJECT
C R E AT E D B Y
PRIT I G AIKWAD
PROJEC T ST EPS 2
A. Data collection - Collected dataset from Kaggle
to analyze the content trends
B. Designed Database - DB Name : NetflixDB
C. Designed Table- Table Name – Netflix_TB
D. Analyzed data - Explored the dataset and then
identified the business requirements that can be
identified using SQL
E- Interpretation, and Reporting - Analyzed and
interpreted data using SQL queries
S Q L TA B L E A N D C O N T E N T S 3
This table contains metadata about TV Shows and Movies available on Netflix. It includes attributes such as
content type, title, director, cast, release information, and description. The structure is designed to support
content filtering, classification, and trend analysis.
Key Columns:
1.show_id: Unique identifier for each content
[Link] type: Indicates whether the content is a Movie or TV
[Link] title: Name of the show or movie
[Link]: Director's name (nullable)
[Link]: List of main cast members (nullable)
[Link]: Country of origin (nullable)
7.date_added: Date when the content was added to Netflix
8.release_year: Year the content was originally released
[Link]: Age rating classification
[Link]: Length of the content (e.g., “90 min” for movies, “2 Seasons” for TV Shows)
11.listed_in: Genre(s) or category tags
12. description: Brief synopsis or summary of the content
B US INE SS PRO B LEM 4
• This project aims to solve 14 real-
world business questions using the
Netflix content dataset. By
leveraging advanced SQL features
like CTEs, window functions,
aggregation, and string manipulation
in MS SQL Server, we extracted
insights related to content trends,
user behavior, regional analysis,
and content moderation. These
queries help uncover patterns such
as most frequent actors, top
content-producing countries,
keyword-based content
categorization, and time-based
content trends on Netflix.
PROB LE M 1 & 2 5
This query helps to find out total count
of Movies and TV shows
This Query helps to identify most
common rating among the content type
PROB LE M 3 & 4 6
This query helps to get the movies which are
released in 2020
This query helps to identify Top 5 countries
with most content on Netflix
PROB LE M 5 & 6 7
This query helps to find out the longest movie
duration wise
This query helps to find out content which are
added in last 5 years
PROB LE M 7 & 8 8
This query will list down the content
which are directed by director Rajiv
Chilka
This query will list down the TV
shows which are having more than
seasons
PROB LE M 9 & 10 9
PROB LE M 11 & 12 10
PROB LE M 13 & 14 11
C OMMA ND S/ FUN CT IO NS U SED 12
• Select | From| Where| Group By | Having | Order BY | Aggregate
• String Split | LTRIM | RTRIM | TOP
• CTEs
• Window Functions
• Dateadd | Getdate