1173

 

 

 

 

 

 方法一

select round(sum(case when order_date=customer_pref_delivery_date then 1 else 0 end)/count(*)*100,2) immediate_percentage
from Delivery;

方法二

select round(sum(if(order_date=customer_pref_delivery_date,1,0))/count(*)*100,2) immediate_percentage
from Delivery;