SQL

E-Commerce SQL Mini-Project

42 business-question SQL queries across six levels, on a six-table MySQL e-commerce schema.

42business-question queries across 6 levels

Stack: SQL, MySQL, Joins, Subqueries, Aggregations

Live demo

A working version of this project will run right here.

Coming soon

Plan: In-browser SQLite (sql.js) loaded with the real schema and seed data, so visitors can run the queries live.

TODO: build and embed the demo

Six levels: Basics, Filtering, Aggregations, JOINs, Subqueries and Set Operations.
Every query is grounded in a realistic business scenario.

Six tables: customers, products, orders, order_items, payments and product_reviews.
The repo includes the schema, seed data and the question bank.