Data Querying & Analysis
A comprehensive SQL analysis project using a sales database with four relational tables: sales transactions, products, geographical regions, and salesperson data. The queries below demonstrate data retrieval, filtering, calculated columns, aggregation, and conditional logic used to extract business insights from the database.
Explore sales performance across products, regions, and salespeople through interactive visualizations built from the SQL database.
Database structure showing four relational tables with primary and foreign key constraints. Sales data connects to geography, products, and salesperson tables.
A collection of SQL queries demonstrating data retrieval, filtering, calculated columns, aggregation, and conditional logic.
SELECT * FROM sales;
SELECT SaleDate, Amount, Customers FROM sales;SELECT Amount, Customers, GeoID FROM sales;
SELECT SaleDate, Amount, Boxes, Amount / boxes FROM sales;
SELECT SaleDate, Amount, Boxes, Amount / boxes AS 'Amount per box' FROM sales;
SELECT * FROM salesWHERE amount > 10000;
SELECT * FROM salesWHERE amount > 10000ORDER BY amount DESC;
SELECT * FROM salesWHERE geoid='g1'ORDER BY PID, Amount DESC;
SELECT * FROM salesWHERE amount > 10000 AND SaleDate >= '2022-01-01';
SELECT SaleDate, Amount FROM salesWHERE amount > 10000 AND year(SaleDate) = 2022ORDER BY amount DESC;
SELECT * FROM salesWHERE boxes > 0 AND boxes <= 50;
SELECT * FROM salesWHERE boxes BETWEEN 0 AND 50;
SELECT SaleDate, Amount, Boxes, weekday(SaleDate) AS 'Day of week'FROM salesWHERE weekday(SaleDate) = 4;
SELECT * FROM people;
SELECT * FROM peopleWHERE team = 'Delish' OR team = 'Jucies';
SELECT * FROM peopleWHERE team IN ('Delish','Jucies');
SELECT * FROM peopleWHERE salesperson LIKE 'B%';SELECT * FROM peopleWHERE salesperson LIKE '%B%';
SELECT SaleDate, Amount, CASE WHEN amount < 1000 THEN 'Under 1k' WHEN amount < 5000 THEN 'Under 5k' WHEN amount < 10000 THEN 'Under 10k' ELSE '10k or more' END AS 'Amount category'FROM sales;
SELECT team, count(*) FROM peopleGROUP BY team;