leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

1174.sql (244B)

      1 SELECT ROUND(100 * AVG(order_date = customer_pref_delivery_date), 2) AS immediate_percentage
      2 FROM Delivery
      3 WHERE (customer_id, order_date) IN (
      4     SELECT customer_id, MIN(order_date) as first_order
      5     FROM Delivery
      6     GROUP BY customer_id
      7 )