思路1
SELECT
ROUND(
(SELECT COUNT(*) FROM Delivery WHERE order_date=customer_pref_delivery_date) /
(SELECT COUNT(*) FROM Delivery) * 100
, 2) AS immediate_percentage;
Last updated
Was this helpful?
SELECT
ROUND(
(SELECT COUNT(*) FROM Delivery WHERE order_date=customer_pref_delivery_date) /
(SELECT COUNT(*) FROM Delivery) * 100
, 2) AS immediate_percentage;
Last updated
Was this helpful?