Task 4 - SQL for Data Analysis

Objective:

Use SQL queries to extract and analyze data from the Olist eCommerce dataset.

Tools Used:

• DB Browser for SQLite
• SQL (SQLite dialect)
• GitHub for version control

Queries Done:

• SELECT, WHERE, ORDER BY
• GROUP BY with aggregate functions
• JOINS (INNER)
• Subqueries
• View Creation
• NULL handling
• Indexing

📸 Output:

All query outputs are provided as screenshots.