✅ Project Overview:

• This project demonstrates SQL query applications for analyzing movie data. It includes practical exercises to retrieve, filter, and sort data based on release year, rating, and studio, making it a great reference for learning SQL in real-world scenarios.

• The reports in this project were inspired by the Codebasics SQL learning module and adapted to provide structured insights through SQL queries.

  ---

✅ SQL Concepts Used:

• SQL Clauses: ORDER BY, WHERE, HAVING

• SQL Operators: IN, BETWEEN, LIKE, NOT EQUAL TO

  ---

✅ Included Reports:

Each report corresponds to an SQL query exercise:

1️⃣ Movies Sorted by Release Year

• Retrieves all movies ordered latest first.

• Query : SELECT title, release_year FROM movies ORDER BY release_year DESC;

2️⃣ Movies Released in 2022

• Filters movies only from the year 2022.

• Query : SELECT title, release_year FROM movies WHERE release_year = 2022;

3️⃣ Movies Released After 2020

• Retrieves movies released after 2020.

• Query : SELECT title, release_year FROM movies WHERE release_year > 2020;

4️⃣ Movies After 2020 with IMDb Rating > 8

• Filters movies released after 2020 with a rating higher than 8.

• Query : SELECT title, release_year,imdb_rating FROM movies WHERE release_year > 2020 HAVING imdb_rating > 8;

5️⃣ Movies by Marvel Studios & Hombale Films

• Selects movies produced only by these studios.

• Query : SELECT title,studio FROM movies WHERE studio in ('Marvel studios' , 'Hombale Films');

6️⃣ All THOR Movies Sorted by Release Year

• Retrieves only THOR movies, sorted chronologically.

• Query : SELECT title,release_year FROM movies WHERE title like '%thor%' ORDER BY release_year ASC;

7️⃣ Movies Not from Marvel Studios

• Selects movies excluding Marvel Studios productions.

• Query : SELECT title,studio FROM movies WHERE studio != 'Marvel Studios';