leetcode

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

1327.sql (216B)

      1 SELECT product_name, SUM(unit) AS unit
      2 FROM Products P
      3 LEFT JOIN Orders O
      4 ON P.product_id = O.product_id AND
      5    YEAR(order_date) = '2020' AND
      6    MONTH(order_date) = '02'
      7 GROUP BY product_name
      8 HAVING SUM(unit) >= 100