E-commerce Sales Analysis - SQL Project

This project models a small electronics retailer and provides SQL queries for analyzing orders, products, customers, employees, monthly sales, and inventory. The source dataset was converted from the supplied schema-and-records text file.

Database target: PostgreSQL 14+ (the SQL script uses PostgreSQL's DATE_TRUNC for monthly aggregation).