leetcodeSolution 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 )