SQL · DoorDash · Hard
A food-delivery marketplace stores its operational history in the tables below. All timestamps are UTC. Treat promotions.discount_amount as the discount that was actually applied to an order, and assume the current date is 2025-09-01 whenever a relative window (such as "the last seven days") is referenced. Write precise SQL for parts (a) through (f), and spell out any assumptions you make about windowing, ties, or missing values. Sample rows (small illustrative data, not a…
Checking your access…