1174. Immediate Food Delivery II.md

1174. Immediate Food Delivery II

Question Link

Solution v1

# Write your MySQL query statement below
select round(sum(if(order_date=customer_pref_delivery_date,1,0))/count(*)*100, 2) as immediate_percentage from Delivery
where (customer_id, order_date) in (
    select customer_id, min(order_date) from Delivery group by customer_id
)

Solution v2

# Write your MySQL query statement below
select round(avg(if(t.order_date = t.customer_pref_delivery_date,1,0))*100, 2) as immediate_percentage
from (
    select * from Delivery d where order_date = (
        select min(order_date) from Delivery where customer_id = d.customer_id
    )
) as t