tseyongg / 8-week-sql-challenge

My solutions to the #8WeekSqlChallenge on SQL Server

🔑 8-Week-SQL-Challenge

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

📝 Table of Contents

Please find the solution links for the case studies below. Simply click on the links to access each solution.

• 🍜Project #1: Danny's Diner
• 🍕Project #2: Pizza Runner