SQL pattern · 6 problems

Subtotals & grouping sets

Graded problems on subtotals & grouping sets, from easy to hard.

6 problems · about 1 h 20 min in all

Start with problem 01Revenue by country with region subtotals and a grand total · 10 min

Easy

1 problem · about 10 min

01Revenue by country with region subtotals and a grand total10 min →

Medium

3 problems · about 38 min

02Totals by channel and by device in one result14 min →03Conversion rate per campaign and overall12 min →04Each country's share of its region and of the total12 min →

Hard

2 problems · about 30 min

05Distinct customers by country, region and overall15 min →06Subtotal report for the categories above a threshold15 min →