[LeetCode] 1174. Immediate Food Delivery II

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH order_timeline AS (
    SELECT *
        , RANK() OVER (PARTITION BY customer_id ORDER BY order_date ASC) AS rnk
    FROM Delivery
)

SELECT ROUND(AVG(CASE WHEN order_date = customer_pref_delivery_date
            THEN 1
            ELSE 0
            END) * 100, 2) AS immediate_percentage
FROM order_timeline
WHERE rnk = 1