Here, I showcase my personal solutions to the 8 case studies from the #8WeekSQLChallenge.
Credit to Data With Danny for the conception of the case studies!
Each project folder contains the following items:
- A readme file explaining the business problem and datasets used
- A solutions folder comprising of a collection of MD files with SQL queries, solution tables, and relevant explanations
- A SQL file to create the schema, tables and loading data
- A full aggregated SQL script containing all the queries
Note:
- Solutions are coded in VSCode, Microsoft SSMS
Please find the solution links for the case studies below. Simply click on the links to access each solution.