Classic Models Database Analysis using SQL queries in MYSQL Workbench
A data analysis mini project performed on the ClassicModels database using MySQL. The project answers 10 real business questions with SQL queries, result screenshots, insights, and strategies.
## Project Files MYSQL_Mini_Project_Question.pdf — Problem statement and business questions MYSQL_Mini_Project_Work_Structured.pdf — All 10 queries with result screenshots MYSQL_Mini_Project_Final_Report.pdf — Final report with insights and strategies MYSQL_Mini_Project.sql — Complete SQL script MYSQL_Mini_Proj_Query - 1 to 10.pdf — Individual query output files
Business Questions Covered Which products generate the highest and lowest revenue? Which product lines result in highest revenue? Who are the top customers and what are their purchasing behaviours? How do seasonal trends and order volumes vary over time? How does order status affect purchases? What is each employee's contribution in processing orders? Does the credit limit of customers affect their purchase amount? Which countries are driving the most revenue? What is the average time to ship across different product lines? Whichproducts have zero sales?
Database ClassicModels — a MySQL sample database with tables covering customers, orders, order details, products, product lines, employees, payments, and offices.
SQL Concepts Used INNER JOIN and LEFT JOIN GROUP BY, ORDER BY, HAVING Aggregate functions — SUM, COUNT, AVG, ROUND UNION for combining result sets DATEDIFF for shipping time calculations Subqueries and NULL checks
Key Findings Classic Cars is the highest revenue-generating product line A small group of customers contribute the majority of total revenue Revenue peaks in Q4, driven by year-end demand Cancelled and disputed orders represent measurable revenue leakage One product (1985 Toyota Supra) has zero sales with 7733 units in stock
Vathada Swaroop Kumar | Ex-TCS | Agileology Platform
- LinkedIn: Swaroop Kumar Vathada