🚀 SQL Project Series #11

Netflix Content Analytics 🎬

Analyze movies and TV shows to uncover trends in content production, genres, ratings, countries, and audience preferences using SQL.

🎯 Business Objectives

✅ Analyze the Netflix content library

✅ Compare Movies vs TV Shows

✅ Identify popular genres

✅ Analyze content ratings

✅ Track yearly content additions

✅ Discover country-wise content trends

✅ Measure content duration

✅ Generate executive dashboards

📂 Step 1: Create Database

CREATE DATABASE netflix_db;
USE netflix_db;

📂 Step 2: Create Content Table

CREATE TABLE netflix_content (
    show_id VARCHAR(20) PRIMARY KEY,
    title VARCHAR(255),
    content_type VARCHAR(20),
    director VARCHAR(255),
    country VARCHAR(100),
    release_year INT,
    date_added DATE,
    rating VARCHAR(20),
    duration VARCHAR(30),
    genre VARCHAR(100)
);

📂 Step 3: Insert Sample Data

INSERT INTO netflix_content VALUES
('S1','Stranger Things','TV Show','The Duffer Brothers','United States',2016,'2022-01-10','TV-14','4 Seasons','Drama'),
('S2','Money Heist','TV Show','Álex Pina','Spain',2017,'2022-02-15','TV-MA','5 Seasons','Crime'),
('S3','Extraction','Movie','Sam Hargrave','United States',2020,'2022-03-01','R','116 min','Action'),
('S4','The Crown','TV Show','Peter Morgan','United Kingdom',2016,'2022-04-18','TV-MA','6 Seasons','Drama'),
('S5','Leo','Movie','Lokesh Kanagaraj','India',2023,'2024-01-20','UA','164 min','Action');

🧠 SQL Concepts You'll Practice

✔ DDL and DML

✔ Filtering and Sorting

✔ Aggregate Functions

✔ GROUP BY

✔ HAVING

✔ CASE WHEN

✔ Date Functions

✔ Window Functions

✔ CTEs

✔ Ranking Functions

📊 Business KPIs You Can Build

📈 Total Titles

📈 Movies vs TV Shows

📈 Content Added by Year

📈 Content Added by Month

📈 Content by Country

📈 Top 10 Producing Countries

📈 Genre Distribution

📈 Most Popular Ratings

📈 Content by Release Year

📈 Oldest and Newest Titles

📈 Average Movie Duration

📈 Longest Movie

📈 TV Shows by Number of Seasons

📈 Top Directors by Number of Titles

📈 Content Growth Trend

📈 Rating-wise Distribution

📈 Action vs Drama vs Comedy Analysis

📈 Percentage of Movies vs TV Shows

📈 Country-wise Content Contribution

📈 Executive Content Dashboard

🎯 This project reflects the type of SQL analysis performed by media companies, streaming platforms, entertainment analysts, and business intelligence teams to understand content strategy and audience trends.

💡 Double Tap ❤️ For More