Why go for solving these case studies?
- Soving these case studies will give you the slightly idea about the actual scenario of real case studies used in industries. With these different case studies, you will get to know more about the different queires while solving it.
What I learned after solving these case studies?
- Got to know different SQL queries like Ranks, denser_rank
- Applying loops in SQL
- Got more confidence to solve more such type of SQL case studies.
Here are the solutions of case studies I performed
- 🍣Danny's Dinner: Wanna have some Sushi or Ramen, let's go through the Danny's dinner where they have varieties of japanese dishes like Ramen, Sushi and curry. my_case1
- 🍕Pizza Runner: Craving for Pizza, let's look into the solution of the case study and have an idea which pizza has maximum orders at the pizza shop. my_case2
Sources:
- Case Study#1- Danny's Dinner
- Case Study#2- Pizza Runner