高频SQL50题（基础版）_1174.即时食物配送II

高频 SQL 50 题（基础版）_1174. 即时食物配送 II

select #ROUND((COUNT(CASE WHEN t2.order_date = t2.customer_pref_delivery_date THEN 1 END) / COUNT(*)) * 100, 2) AS #immediate_percentage round((count(case when t2.order_date = t2.customer_pref_delivery_date then 1 end)/count(*))*100 ,2) as immediate_percentage from (select customer_id , min(order_date) as order_date from Delivery group by customer_id ) as t1 left join Delivery as t2 on t1.order_date = t2.order_date and t1.customer_id = t2.customer_id