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.

This case study really helped me deepen my understanding of Aggregate functions, Window functions, CASE statements, CTEs, and more.
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.
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.