SQL Project β Sales Database π Overview This project demonstrates database design and SQL queries for a Sales Management System. It includes creating tables, inserting sample data, and running queries to get useful business insights.
π Database Design Customers β Customer details (ID, Name, City, Country) Products β Product details (ID, Name, Price, Category) Orders β Orders placed by customers (Order ID, Customer ID, Date) OrderDetails β Links products with orders (Quantity of each product)
π Example Queries List all customers and products Find orders made in 2024 Calculate total sales by each customer Identify the best-selling product Find customers who purchased a Laptop
π― Skills Used SQL Database Design Joins & Relationships Aggregation (SUM, COUNT, AVG, GROUP BY) Data Analysis with SQL