Skip to content

2686. Immediate Food Delivery III 👍

1
2
3
4
5
6
7
8
9
SELECT
  order_date,
  ROUND(
    AVG(order_date = customer_pref_delivery_date) * 100,
    2
  ) AS immediate_percentage
FROM Delivery
GROUP BY 1
ORDER BY 1;