Companies store large amounts of transaction data in databases. The goal of this project is to use SQL to extract useful information such as revenue trends, top-selling products, and profitable categories to support decision-making.
Skills Demonstrated
- SELECT statements
- WHERE filtering
- GROUP BY aggregation
- ORDER BY sorting
- Aggregate functions (SUM, COUNT, AVG)
- Business reporting queries
Total Sales Revenue
SELECT SUM(Sales) AS Total_Revenue FROM orders;
SELECT Category, SUM(Sales) AS Revenue FROM orders GROUP BY Category ORDER BY Revenue DESC;
SELECT YEAR(Order_Date) AS Year, MONTH(Order_Date) AS Month, SUM(Sales) AS Monthly_Revenue FROM orders GROUP BY YEAR(Order_Date), MONTH(Order_Date) ORDER BY Year, Month;
This project demonstrates the ability to query business databases and generate reports required by management and stakeholders.