Here are my solutions to the 8 weeks sql challenge of danny ma, there he gives you the option to use an online platform to deploy your schemas, and execute queries against them, but i took the opportunity to use Docker and Dbeaver to manage my Postgresql database.
| Name | Description | Status |
|---|---|---|
| Case Study #1 - Danny's Diner | Danny’s Diner is in need of your assistance to help the restaurant stay afloat. Danny wants to use the data to answer a few simple questions about his customers, especially about their visiting patterns, how much money they’ve spent and also which menu items are their favourite. | Completed |
| Case Study #2 - Pizza Runner | Danny requires further assistance to clean his data and apply some basic calculations so he can better direct his runners and optimise Pizza Runner’s operations. | In Progress |
| Case Study #3 - Foodie-Fi | This case study focuses on using subscription style digital data to answer important business questions. | To begin |