SQL Store Sales Analysis

A sales analysis project using MySQL on Mosh Hamedani's sql_store database.

Questions Answered

1. Top 5 Customers by Total Spend

2. Most Ordered Products

3. Monthly Revenue Trend

4. Products Never Ordered

5. Average Order Value per Customer

Key Findings

• Top customer is Ines Brushfield with $157.92 total spend
• Most ordered product is Lettuce - Romaine Heart with 28 units
• Only Sweet Pea Sprouts has never been ordered
• Thacher Naseby has the highest average order value at $91.20

Skills Used

• JOINS (INNER, LEFT)
• GROUP BY and HAVING
• Aggregate functions (SUM, COUNT, AVG, ROUND)
• String functions (CONCAT)
• Date functions (YEAR, MONTH)
• Subqueries