leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
1084.sql (196B)
0 SELECT P.product_id, P.product_name 1 FROM Product P 2 LEFT JOIN Sales S 3 ON P.product_id = S.product_id 4 GROUP BY P.product_id 5 HAVING MIN(sale_date) >= '2019-01-01' AND MAX(sale_date) <= '2019-03-31';