Data Coding

May delivery check

EasyDoorDashfiltertime differencestip ratejoins· 20 XP (10 per step)

Mock interview. You're interviewing for a data analyst job on a food delivery team. The interviewer shares deliveries and restaurants. "Let's see how May went."

  • Delivery time is from ordered_at to delivered_at, in minutes.
  • Gross order value (GOV) is the sum of order_total for delivered orders.
  • Tip rate is total tips / GOV for delivered orders, where a missing tip counts as 0.

Step 1: The headline numbers

"Give me May 2026 in one row: orders, cancellation rate, average delivery time, GOV and tip rate."

Expected output

  • One row; cancel_rate and tip_rate as percentages rounded to 1 decimal; avg_delivery_min rounded to 1 decimal

Example of the shape (made-up values):

orders cancel_rate avg_delivery_min gov tip_rate
550 5.0 40.0 24000.00 10.0

Hints, the later steps and the answer come with Pro.

Step 1 of 2

Write your query here. Ctrl + Enter submits.