Candidates write and run queries in a hands-on environment, and grading compares the output with the expected result — from basic SELECT to joins and window functions.
SELECT c.region, o.month,
SUM(o.total) AS revenue,
RANK() OVER (PARTITION BY o.month
ORDER BYSUM(o.total) DESC) AS rk
FROM orders o JOIN customers c ON c.id = o.customer_id
GROUP BY c.region, o.month;
region
month
revenue
rk
Southeast
2026-08
1,284,300
1
South
2026-08
642,910
2
Northeast
2026-08
508,120
3
Midwest
2026-08
311,480
4
All your favorite tools, connected
Our ecosystem of deep integrations makes it easy to streamline your hiring processes.
