WMA Hub

SQL Lab: Retail Sales and Returns (synthetic)

Two years of invented supermarket sales across 12 stores and an online shop, with products, loyalty customers, discounts and returns.

FreshCart is an invented retail chain with hypermarkets, supermarkets, express stores and an online shop in five regions. The category manager wants to understand which products and stores make money after discounts and returns, how promotions affect margin, and whether loyalty customers are worth the extra attention.

Write SQL on this sample data and see the results. It runs in your browser with SQLite, so it is not SQL Server, MySQL or PostgreSQL.

All SQL Lab datasets