Efficient Query
Code\n\nselect product_id , year as first_year , quantity , price from sales \nwhere (product_id , year) in (select product_id , min(year) as year \n           
# Code\n```\nselect product_id , year as first_year , quantity , price from sales \nwhere (product_id , year) in (select product_id , min(year) as year \n                              from sales group by product_id)\n\n\n```
['MySQL']