leetcode

Solution to some Leetcode problems written in C++

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

1164.sql (342B)

0 SELECT DISTINCT product_id, 10 AS 'price' 1 FROM Products 2 GROUP BY product_id 3 HAVING MIN(change_date) > "2019-08-16" 4 UNION ALL 5 SELECT product_id, new_price 6 FROM Products 7 WHERE (product_id, change_date) IN ( 8 SELECT product_ID, MAX(change_date) as recent_date 9 FROM Products 10 WHERE change_date <= "2019-08-16" 11 GROUP BY product_id 12 )