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';