1174-immediate-food-delivery-ii

DevGod

Elf Vtuber

Tip

DevGod also tweets about solutions :)

Caution

DevGod needs to write an editorial for this problem!

sql

SELECT ROUND(AVG(order_date=customer_pref_delivery_date)*100,2) as immediate_percentage
FROM(
    SELECT *,
    rank() over (partition BY customer_id order by order_date) as R
    FROM Delivery
) t
WHERE R=1