SQL Retail Assignment

A practical MySQL project focused on customer and order analysis using a retail dataset.

📌 Project Overview

This assignment contains 12 SQL questions designed to practice real-world data analysis and business problem-solving using MySQL.

🛠️ SQL Concepts Covered

• SELECT & WHERE
• ORDER BY
• LIMIT & OFFSET
• Filtering with AND / OR
• Date Functions
• DATEDIFF()
• DATE_ADD()
• INNER JOIN
• LEFT JOIN
• SELF JOIN
• GROUP BY
• Aggregate Functions
• CASE WHEN
• Subqueries

📊 Tables Used

Customers

• CustomerID
• CustomerName
• City
• JoinDate

Orders

• OrderID
• CustomerID
• OrderDate
• OrderAmount
• Status

🎯 Objective

The objective of this project is to strengthen SQL querying skills and apply SQL concepts to practical retail business problems.

💻 Tool

MySQL Workbench

👤 Author

Deepak Singh