Bad Experience Rate for New Users

SQLMediumMid levelDoorDash~15 min

Problem

**[Asked at DoorDash]**

DoorDash defines a **bad experience** as an order that was either:
- Delivered with the wrong items (`outcome = 'incorrect'`)
- Never received (`outcome = 'not_received'`)
- More than 30 minutes late (`minutes_late >= 30`)

For new users who signed up in **June 2022**, calculate the bad experience
rate for their orders placed **within the first 14 days** of signup.

Return a single value `bad_experience_rate` as a percentage rounded to 2 dp.

Tables

Example rows — the live problem includes the full dataset.

customers

customer_id	name	signup_date

deliveries

delivery_id	customer_id	order_date	outcome	minutes_late

Expected output

Your answer should return 1 row with the columns bad_experience_rate.

Starter code (SQL)

SELECT *
FROM customers;

Solve this SQL question free

Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.

Solve it now → Create free account

Solution & explanation

Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.