1174.immediate-food-delivery-ii.sql

--
-- @lc app=leetcode id=1174 lang=mysql
--
-- [1174] Immediate Food Delivery II
--

-- @lc code=start
# Write your MySQL query statement below
SELECT 
    ROUND(
        (SUM(CASE WHEN order_date = customer_pref_delivery_date THEN 1 ELSE 0 END) 
        / COUNT(*)) * 100, 2) AS immediate_percentage
FROM (
    SELECT 
        customer_id,
        MIN(order_date) AS first_order_date
    FROM 
        Delivery
    GROUP BY 
        customer_id
) AS first_orders
JOIN Delivery AS d
ON first_orders.customer_id = d.customer_id 
AND first_orders.first_order_date = d.order_date;


-- @lc code=end