题目来源:
leetcode题目,网址:1173. 即时食物配送 I - 力扣(LeetCode)
解题思路:
筛选出符合条件的配送然后对其计数,然后计算结果并按要求输出即可。
解题代码:
# Write your MySQL query statement below
select round(count(a.delivery_id)/count(Delivery.delivery_id)*100,2) as immediate_percentage
from (select *
from Delivery
where order_date=customer_pref_delivery_date) as a
right join Delivery on a.delivery_id=Delivery.delivery_id
总结:
官方题解给出了三种解法。第一种是做两次 select count(*)然后直接相除。第二种是使用sum(case when)和count(*) 计数。第三种是直接sum(condition) 和count(*)计数。