netflix_data_analysis

SQL is used to extract valuable insights and answer various business questions based on the dataset. The dataset contains a comprehensive listing of movies and tv shows on Netflix.

The data for this project is sourced from Kaggle

Schema of table in SQL Server

CREATE TABLE netflix_data
(
    show_id      VARCHAR(5),
    type         VARCHAR(10),
    title        VARCHAR(250),
    director     VARCHAR(550),
    casts        VARCHAR(1050),
    country      VARCHAR(550),
    date_added   VARCHAR(55),
    release_year INT,
    rating       VARCHAR(15),
    duration     VARCHAR(15),
    listed_in    VARCHAR(250),
    description  VARCHAR(550)
);