SQL_CASE_STUDY

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.
3	Pizza Runner	The SQL case-study pizza runner consists of runners, customer_orders, runner_orders, pizza_names, pizza_recipes and pizza_toppings. Cleaned and preprocessed data from the pizza runner database. Conducted exploratory data analysis to address key questions from the case study. Functions like GROUPBY, WHERE, CASE, SUMIF, SUM, AVG, ROUND, TIMESTAMPDIFF, MONTH, YEAR, EXTRACT, EXCEPT, NOT IN, IN and CTEs were used.
4	Data Mart	The SQL case-study data mart