ThomasM524/freshmart-ghana-sql-analysis

# FreshMart Ghana — SQL Analysis A SQL practice project analyzing FreshMart Ghana's retail operations — customers, orders, products, suppliers, and returns — using a relational MySQL database. ## Overview This project demonstrates core to advanced SQL skills across 14 tasks: filtering, aggregation, joins, subqueries, and conditional logic, run against a 6-table relational schema (`customers`, `orders`, `order_items`, `products`, `suppliers`, `returns`). ## Tasks Covered 1. Basic Selection & Sorting 2. Categorical Filtering 3. Multi-Condition Filtering 4. Logical Set Operations (IN) 5. Aggregation & Grouping 6. Aggregated Group Filtering (HAVING) 7. Statistical Descriptive Metrics (AVG, MIN, MAX) 8. Relational Inner Joins 9. Inclusive Outer Joins (LEFT JOIN) 10. Multi-Table Transaction Evaluation 11. Subquery Unification (IN subquery) 12. Scalar Subquery Filtering 13. Conditional Logic Fields (CASE) 14. Comprehensive Unified Synthesis (multi-join + aggregation) ## Tech Stack - MySQL ## Repository Structure data/ Full database dump (schema + data) — freshmart_full_dump.sql sql/ Assignment queries — all 14 tasks in one file docs/ Assignment instructions (epub) and evidence report (PDF) with query + output screenshots for each task ## Author Thomas Munyambu Mutua — Credit Analyst, Watu Credit GitHub: ThomasM524