8 Week SQL Challenge - https://8weeksqlchallenge.com/

SQL Case studies done by Gino Hobayan

Getting better at SQL, one line of code at a time.

This SQL Challenge is an excellent way to apply all the theoretical SQL knowledge I learned from DataCamp's SQL Fundamentals and the Google Data Analytics Certificate.

I used the following:

• Microsoft SQL Server for Case Study #1 - Danny's Diner and #2 - Pizza Runner
• PostgreSQL (Using DB fiddle) for Case Study #7 - Balanced Tree Clothing Co.

1.) Danny's Diner

PDF 👉 https://drive.google.com/file/d/1jLHWro41mbfpemUymKv97JmIPyvwgbmz/view?usp=sharing

This case study really helped me deepen my understanding of Aggregate functions, Window functions, CASE statements, CTEs, and more.

2.) Pizza Runner

Link to my Solution 👉 https://github.com/Gino-Freud-Hobayan/8WeekSQL_Challenge/tree/main/2.)%20Pizza%20Runner

Got to practice more Data cleaning and SQL queries.

Currently a work in progress.

7.) Balanced Tree Clothing Co.

Link to my Solution 👉 https://github.com/Gino-Freud-Hobayan/8WeekSQL_Challenge/tree/main/7.)%20Balanced%20Tree%20Clothing%20Store

Just tried this case study since it looked interesting.