mysql intuitive and easy solution
\nselect product_id, year as first_year, quantity, price from sales\nwhere (product_id, year) in\n\n(\nselect product_id, min(year) from sales\ngroup by product
```\nselect product_id, year as first_year, quantity, price from sales\nwhere (product_id, year) in\n\n(\nselect product_id, min(year) from sales\ngroup by product_id\n    )\n```
[]