This project contains a structured SQL database for a fictional store, including customer data, product listings, order records, and detailed sales transactions.
The database includes the following tables:
Customers: Stores customer contact information.Products: Contains product names, categories, and prices.Orders: Records order dates and associated customers.OrderDetails: Tracks product quantities and unit prices per order.
The SQL queries in this project are designed to:
- Retrieve customer contact details.
- Filter products by price.
- Join orders with customer information.
- Calculate total revenue.
- Analyze product sales performance.
This project is ideal for:
- Practicing SQL joins, aggregations, and filtering.
- Building educational dashboards.
- Teaching database relationships and query logic.
Feel free to explore, adapt, and extend the queries in the accompanying file!