Elevate-Labs-Internship-Task-3

Task 3: SQL for Data Analysis

📌 Objective

This task is part of a Data Analyst Internship and focuses on using SQL queries to extract and analyze data from a PostgreSQL database.

---

🛠 Tools Used

• PostgreSQL
• pgAdmin / DBeaver
• Dataset: cleaned_superstore_iso.csv (imported as public."Superstore" table)

---

✅ Tasks Performed

1. Basic Data Exploration

   • Selected first 10 rows
   • Filtered orders by date

2. Aggregations

   • Total sales
   • Average discount

3. Group-wise Analysis

   • Sales by Category
   • Profit by Region

4. Subqueries

   • Found customers with sales above average

5. Views

   • Created a monthly sales view

6. Query Optimization

   • Created indexes on order_date and customer_id

7. Null Handling

   • Used COALESCE and counted NULL values

---

📂 Repository Contents

• task3_queries.sql – All SQL queries
• Screenshots/ – Folder with screenshots of query results
• README.md – This file

---

📸 Screenshots

Screenshots of all query outputs are available in the Screenshots/ folder.