This project demonstrates SQL skills by analyzing a sample e-commerce dataset. It includes customer, orders, and order items data. The goal is to extract insights using SQL queries.
Three tables:
customers: Basic user information.orders: Orders with total amount and date.order_items: Items included in each order.
- MySQL
- SELECT, WHERE, ORDER BY
- Aggregate functions: SUM, AVG, COUNT
- JOINs
- Subqueries
- Views
- Indexes (if needed)
- Total spend per customer
- Most valuable customers
- Order value trends
- Query results