leetcode

Solution to some Leetcode problems written in C++

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

1070.sql (211B)

1 SELECT product_id, 2 year AS first_year, 3 quantity AS quantity, 4 price 5 FROM Sales 6 WHERE (product_id, year) IN ( 7 SELECT product_id, MIN(year) AS year 8 FROM Sales 9 GROUP BY product_id 10 )