📊 8-Week SQL Challenge

Welcome to my 8-Week SQL Challenge Repository! 🎯
This repository contains SQL solutions and story points for various real-world case studies aimed at improving SQL proficiency.

📌 Overview

This challenge is designed to test and enhance SQL skills through real-life business scenarios. Each week focuses on a different dataset with unique business problems and SQL queries to extract insights.

🗂️ Repository Structure

The repository is organized as follows:

Each week folder contains:

• Case_Study.md → Describes the business case and insights gained.
• .sql files → Contains SQL queries used to solve the case study.
• ER_Digram.png files → Table relation diagram of the case study.

---

🚀 Case Studies Covered

🏪 Week 1: Danny's Diner

• Analyze customer spending behavior for a restaurant.
• SQL skills: JOIN, CASE, AGGREGATIONS, WINDOW FUNCTIONS.

🛒 Week 2: Pizza Runner

• Track pizza delivery operations & identify inefficiencies.
• SQL skills: STRING FUNCTIONS, CTE, TEMP TABLES.

🏦 Week 3: Foodie-Fi

• Subscription-based business revenue analysis.
• SQL skills: DATE FUNCTIONS, SUBQUERIES, RANK().

📦 Week 4: Data Bank

• Financial transactions & fraud detection.
• SQL skills: SELF-JOINS, PARTITION BY, GROUP BY.

🏥 **Week 5: Data Mart **

• .
• SQL skills: .

---

💡 How to Use

1. Clone this repository:

   git clone https://github.com/yourusername/8-Week-SQL-Challenge.git

2. Open the .sql files in any SQL database (PostgreSQL, MySQL, SQL Server).
3. Run the queries and analyze the results.

🛠 Prerequisites

• PostgreSQL or MySQL installed
• SQL knowledge (Beginner to Intermediate level)
• Any SQL query tool (DBeaver, pgAdmin, MySQL Workbench)