leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
1174.sql (244B)
0 SELECT ROUND(100 * AVG(order_date = customer_pref_delivery_date), 2) AS immediate_percentage
1 FROM Delivery
2 WHERE (customer_id, order_date) IN (
3 SELECT customer_id, MIN(order_date) as first_order
4 FROM Delivery
5 GROUP BY customer_id
6 )