leetcode

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