Practice

10-Minute Foundations Sprint

Practice Sprint Timer

Start with a first-correct query, then use remaining minutes for validation and cleanup.

20:00

This sprint trains fast correctness on core patterns.

Time budget:

  • 0-4 min: Drill 1
  • 4-10 min: Drill 2

Drill 1: Daily Completed Orders #

Return one row per day for completed orders.

Required output columns:

  • day
  • completed_orders
  • revenue
Loading SQL editor...

Drill 2: Top Countries by Completed Revenue #

Return the top 3 countries by completed-order revenue. More than 3 countries have completed orders, so the LIMIT must actually drop rows.

Sort by revenue descending; break ties by completed_orders descending, then country alphabetically.

Required output columns:

  • country
  • completed_orders
  • revenue (rounded to 2 decimals)
Loading SQL editor...
Tip

Passing score target: >= 11/15 across both drills. Re-run once and focus on query clarity.