leetcode

Solution to some Leetcode problems written in C++

git clone git://git.dimitrijedobrota.com/leetcode.git

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 )