题目:原题链接(简单)
标签:SQL
解法 | 时间复杂度 | 空间复杂度 | 执行用时 |
---|---|---|---|
Ans 1 (Python) | 336ms (74.70%) | ||
Ans 2 (Python) | |||
Ans 3 (Python) |
解法一:
SELECT ROUND((SELECT COUNT(delivery_id)
FROM Delivery
WHERE order_date = customer_pref_delivery_date)
/
(SELECT COUNT(delivery_id)
FROM Delivery)
* 100
, 2) AS immediate_percentage;