ID |
CASE-STUDY |
DESCRIPTION |
|---|---|---|
| 1 | DANNY'S DINER | The SQL case-study danny's dinner consists of sales, members and menu as three datasets. The case-study is provided with ten questions. Some of the functions used to answer the danny's diner queries include SUM, AND, WHERE, GROUP BY, ORDER BY, JOIN, DISTINCT, COUNT, CASE, LIMIT and CTE. |
| 2 | BURGER BASH | The Burger-Bash case-study consists of four datasets such as runner_orders, burger_orders, burger_names and customer_orders. Several functions, including SELECT, WITH, GROUP BY, JOIN, DISTINCT, CTE, AS, CASE, SUM, and EXTRACT are used to answer the burger-bash queries. |