Task 3 - SQL for Data Analysis

Objective Use SQL to extract and analyze data from a sample eCommerce dataset using DB Browser for SQLite. Tools Used

• DB Browser for SQLite
• SQL (SQLite syntax)

Dataset A mini eCommerce dataset containing:

• Customers
• Products
• Orders

---

SQL Concepts Applied

• SELECT, WHERE, ORDER BY, GROUP BY
• JOINS
• Subqueries
• Aggregate Functions (SUM, COUNT)
• Views
• HAVING clause

---

Files Included

• task3_queries.sql: SQL script with schema, inserts, and queries
• screenshots/: Query results
• ecommerce.db: SQLite database (optional)

How to Run

1. Open DB Browser for SQLite
2. Load ecommerce.db or run task3_queries.sql
3. Go to Execute SQL and run queries
4. View results under the Browse Data tab