Project Overview
This project involves analyzing sales data for Danny's Dinner, a restaurant. The goal is to gain insights into customer behavior, sales trends, and product performance using SQL. The project encompasses various data manipulation tasks, including data cleaning, joining tables, and performing complex queries to answer specific business questions.
Schema and Data Setup
- Step 1: Create Schema:
- Step 2: Create Sales Table:
- Step 3: Insert Data into Sales Table:
- Step 4: Create Menu Table:
- Step 5: Insert Data into Menu Table:
- Step 6: Create Members Table:
- Step 7: Insert Data into Members Table:
