Solutions for the 8 Week SQL Challenge covering real world business case studies focused on SQL problem solving and analytical querying.
- Danny's Diner
- Pizza Runner
- Foodie-Fi
- Data Bank
- Data Mart
- Clique Bait
- Balanced Tree
- Fresh Segments
Each case study contains:
- Dataset files
- Database creation script
- Database schema
- Problem statements
- SQL solutions
- Aggregations
- Joins
- Subqueries
- CTEs
- Window Functions
- Ranking Functions
- Date Functions