SQL ✅ || WHERE || Subquery || MIN ||  Easy Solution
\n\n\n# Code\n\n# Write your MySQL query statement below\nselect \nproduct_id, year as first_year, quantity, price\nfrom Sales\nwhere(product_id, year) in (sele
![e2515d84-99cf-4499-80fb-fe458e1bbae2_1678932606.8004954.png](https://assets.leetcode.com/users/images/61b0d9bd-5ed4-4ce8-a135-4360fc67c701_1684946369.0075927.png)\n\n\n# Code\n```\n# Write your MySQL query statement below\nselect \nproduct_id, year as first_year, quantity, price\nfrom Sales\nwhere(product_id, year) in (select product_id, min(year) from Sales group by product_id)\n\n```
['Database', 'MySQL']