leetcodeSolution 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