leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

1070.sql (211B)


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