文章目录
题目
代码(7.18 首刷看解析)
找到首次订单就是根据不同用户找到最小的日期
(customer_id, order_date) in
可以将表的两项进行同时比较,效率更高
# Write your MySQL query statement below
select round(sum(order_date=customer_pref_delivery_date)*100/count(1), 2) immediate_percentage
from Delivery where (customer_id, order_date) in
(select customer_id, min(order_date) from Delivery group by customer_id)