BeginnerFree account required
Analyse sales across a store network
Build revenue indicators from fictional sales across several cities and channels.
SELECTWHEREGROUP BYSUMORDER BY
45 to 60 minCreate a free account Guided projects
Move from an isolated query to a complete analysis.
Every project combines a business objective, a dataset, several tasks and a SQL environment.
IntermediateSQL Essentials
Manage the margin of an e-commerce catalogue
Join orders, order lines and products to distinguish revenue, costs and margin by category.
Multiple joinsCTEsCalculationsGROUP BYChecks
75 to 100 minView SQL Essentials IntermediateIn preparation
Monitor products and stock-out risk
Prepare stock, rotation and coverage indicators for an operations team.
CASEJOINAggregationsCTEs
60 to 90 minContent in preparationIntermediateIn preparation
Segment customers from their orders
Turn order history into useful segments for a marketing team.
JOINCASEDatesCTEs
60 to 90 minContent in preparation