🧠 SQL Case Studies

Welcome to my SQL Case Study repository where I’ve solved real-world analytical problems using structured datasets. This repository includes major case studies:

1. Olympics Athlete Analysis
2. Credit Card Transaction Analysis
3. Longest Query
4. Netflix Data Analysis and Visual

---

📁 Datasets Used

1. Athlete Case Study

• Source: provided by Ankit Bansal in his NamasteSQL course
• Columns Include:
  • Athlete name, gender, team, year, season, sport, event, medal (Gold/Silver/Bronze)

2. Credit Card Transactions

• Source: provided by Ankit Bansal in his NamasteSQL course

• Details:

  • Transaction data from cities like Delhi, Bengaluru, and Mumbai
  • Card types: Gold, Silver, Platinum, Signature
  • Expense categories: Bills, Travel, Fuel, etc.
  • Customer gender and transaction amount

  3. Longest Query

  • Source: https://lnkd.in/grwVRvVg
  • Details:
    • Employees Details
    • Salary History

  4. Netflix Data Analysis and Visual

  • Source: https://lnkd.in/grwVRvVg
  • Details:
    • Netflix data from 2008 to mid 2021
    • Columns Include : show_id, content_type , title ,genre_type , cast, director, date_added, rating, duration, description, release_year

🧰 SQL Concepts Used

• GROUP BY, ORDER BY, HAVING
• Window Functions: RANK(), ROW_NUMBER(), LAG(), LEAD()
• Conditional Logic: CASE, IF, COALESCE
• String aggregation: STRING_AGG()
• Filtering: WHERE, IN, NOT IN
• CTEs (Common Table Expressions)
• Subqueries and Nested Queries
• Date functions: YEAR(), MONTH(), DATEPART(), DATEDIFF()
• Cross Apply

---

📊 Tools

• SQL Server Management Studio (SSMS)
  • Datasets cleaned and analyzed entirely in SQL
• Excel and Power BI
  • Data Visualization

---

📎 License

This project is open for learning and sharing. Attribution appreciated.