Task 3 – SQL for Data Analysis

This task uses the Mall_Customers dataset to practice SQL queries such as:

• SELECT
• WHERE
• GROUP BY / HAVING
• JOIN (not required since dataset is single table)
• Subqueries
• Aggregate functions (AVG)
• Views
• Indexing
• Handling NULL values

Tools Used

• DB Browser for SQLite
• Mall_Customers.csv

What I Did

1. Imported Mall_Customers.csv into SQLite as a table named "customers".
2. Wrote SQL queries to analyze the dataset.
3. Created a SQL file (queries.sql).
4. Executed queries and captured screenshots of results.
5. Uploaded everything to GitHub.

Files Included

• queries.sql
• Mall_Customers.csv
• Screenshots of executed SQL queries
• customer database (mall.db)