sql_queries

This task is part of the Internship program. The objective is to use SQL to perform data analysis operations on an ecommerce dataset. The task involves writing queries to filter, join, aggregate, and summarize data using SQL commands .

📊 Task 4 : SQL for Data Analysis

✅ Objective

Use SQL to extract, manipulate, and analyze structured data using queries, joins, subqueries, and views.

---

🛠 Tools Used

• SQLite (via DB Browser)
• Dataset: Ecommerce_SQL_Database (or Chinook)
• GitHub for version control

🧾 What I Did

1. SELECT, WHERE, ORDER BY, GROUP BY

• Filtered customers by city
• Sorted products by price
• Counted orders per customer

2. JOINS

• Used INNER JOIN for customer-order data
• Used LEFT JOIN for product-category data

3. Subqueries

• Fetched customers with more than 5 orders

4. Aggregate Functions

• Calculated average order value and total revenue

5. Views

• Created a view to summarize customer order revenue

6. Indexing

• Created an index on orders.customer_id to optimize JOINs

💼 Author

Prachee

Linkedin Profile :(https://www.linkedin.com/in/prachee-chahar-6637832a1)