SQL Foundations Portfolio

Built during a structured 1-day SQL intensive. All queries run on SQLiteOnline.com.

What I Learned

• SQL fundamentals: SELECT, WHERE, GROUP BY, HAVING, JOINs
• Advanced SQL: Window functions (RANK, LAG, DENSE_RANK), CTEs, Subqueries
• Applied analytics: Translating business questions into SQL queries

Projects

1. Superstore Revenue Autopsy (day1-evening/superstore_autopsy.sql)

10 SQL queries answering real business questions on the Kaggle Superstore dataset.

3 Key Insights I Found:

• Insight 1: [Fill in — e.g. "The Central region has 4% profit margin vs West's 14%"]
• Insight 2: [Fill in — e.g. "Tables sub-category loses $X per order due to 40%+ discounts"]
• Insight 3: [Fill in — e.g. "Corporate segment has 2x higher LTV than Home Office"]

2. SQL Murder Mystery (day1-evening/murder_mystery.sql)

Solved the full SQL Murder Mystery using a 9-step JOIN query chain. Documented detective logic as SQL comments.

Villain found: [NAME] — hired by mastermind [NAME]

3. Sales Leaderboard (day1-evening/sales_leaderboard.sql)

Executive-ready quarterly sales leaderboard using CTEs + RANK() + LAG(). Features QoQ trend arrows, margin %, and performance tier classification.

Dataset

Superstore Sales dataset from Kaggle. Not included in repo — download separately and import to SQLiteOnline.com.

Skills Demonstrated

SELECT JOIN GROUP BY HAVING WINDOW FUNCTIONS CTE SUBQUERIES CASE