Scenario 1 of 5
A plain data question
Asked as Mekong Noodle House
How did delivery compare with the counter last week?
What should happen
- One SQL query, completed orders only, in the restaurant's local time.
- Says which week the figures cover and how it defined delivery and counter.
What happened
Last week I took to be Monday Oct 19 to Sunday Oct 25, 2026, in local time. I counted completed orders only. I read "delivery" as the three marketplace channels (DoorDash, Uber Eats and Grubhub) and "counter" as the in-store channel. Your policies don't define either term.
- Delivery: 835 orders, $34,063.69 gross sales and $2,126.54 in discounts. That leaves $31,937.15 before refunds, and the average order was about $40.79 gross.
- Counter: 605 orders, $19,392.10 gross sales and $989.71 in discounts. That leaves $18,402.39 before refunds, and the average order was about $32.05 gross.
Delivery brought in about 38% more orders and about 76% more gross sales than the counter. Its orders were also about $8.74 larger on average. Delivery carries platform commission on top of those figures, so its net payout will be lower than the sales comparison suggests. I didn't calculate commission.
I left out Square Online, including its 136 delivery orders. If you meant all delivery by fulfillment type, tell me and I'll rerun it.
answered
- $0.0235to answer, $0.0331 without the prompt cache
- 17.7 s16.1 s in the model
- 7steps, 10,704 tokens in, 1,172 out
- asked:1 time
- avg cost:$0.0182
- avg time:8.9 s
Captured on October 31, 2026. Rerunning puts the same question to the agent live, for a few cents and about ten seconds. Each run is kept so you can flip between them.