SQL Data Analysis Internship Task

📌 Overview

This project contains my solution to Task 3 & Task 4 from the Data Analyst Internship test.
It focuses on SQL query writing, optimization, and data analysis using an Ecommerce dataset.

📂 Repository Structure

• dataset/ → Ecommerce dataset (sample SQL/CSV)
• queries.sql → All SQL queries with explanations
• README.md → This file (documentation)

⚡ Queries Covered

1. Difference between WHERE and HAVING
2. Types of Joins (INNER, LEFT, RIGHT)
3. Average Revenue per User
4. Subqueries
5. Query Optimization
6. Views in SQL
7. Handling NULL values
8. Aggregates (SUM, AVG)
9. Data filtering (SELECT, WHERE, ORDER BY)

🛠 Tools Used

• Database: MySQL (can also work on PostgreSQL/SQLite)
• IDE: MySQL Workbench / DBeaver / SQLite CLI

🚀 How to Run

1. Import the dataset from /dataset/
2. Run queries in queries.sql

📤 Submission

Submission Form: Link