🎥 IMDB - Movie Database Analyzer

A collection of powerful SQL queries to explore and analyze a large IMDB movie database.

✨ Overview

This project challenges you to write SQL queries on a real-world movie database containing information about thousands of movies, actors, directors, ratings, and genres.

From finding specific movies to analyzing ratings and finding popular actors — this project significantly improves your SQL skills.

🎯 Features

• ✅ 13 progressively challenging SQL queries
• ✅ Works with a large real IMDB-style SQLite database
• ✅ Covers:
  • Basic SELECT and WHERE clauses
  • JOINs across multiple tables
  • Aggregate functions (COUNT, AVG, MAX)
  • Subqueries and nested queries
  • Pattern matching with LIKE
  • Ordering and limiting results

🚀 Quick Start

# Clone the repository
git clone https://github.com/kabincs9/imdb.git
cd imdb

# Open the database
sqlite3 movies.db
Then run the queries from the provided .sql files or directly in the SQLite prompt.
📋 Queries Included

Finding movies released in a specific year
Finding the birth year of a particular actor/actress
Listing all movies a person has acted in
Finding highest rated movies
Identifying movies with specific genres
Finding collaborators of a famous actor
And many more complex analytical queries

🧠 What I Learned

Advanced SQL query writing
Working with multiple related tables using JOINs
Using subqueries effectively
Analyzing large datasets with aggregate functions
Real-world database schema understanding
Optimizing queries for performance

🛠️ Built With

SQLite
SQL
CS50’s IMDB movie database (movies.db)


⭐ Star this repo if you enjoy movies and want to master SQL queries!
Made with ❤️ by Kabin
text---

**Ready to use!**

Just copy the entire content above into your `README.md` file for the **imdb** repository.

Would you like me to make any changes? For example:
- Add a section showing sample query outputs?
- Make it more spoiler-free?
- Change the tone?

Also, tell me the **next project** you want (e.g., **Movies**, **Fiftyville** was already done, **Houses**, **Songs**, or **Week 8** projects like **Trivia**, **Homepage**, etc.).

Just say the name!