leetcode

Solution to some Leetcode problems written in C++

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

1327.sql (216B)

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