my SQL inner join solution - works
select s.product_id, first_year, quantity, price \nfrom sales s \ninner join(\nselect product_id, min(year) as first_year  \nfrom sales \ngroup by product_id \n
select s.product_id, first_year, quantity, price \nfrom sales s \ninner join(\nselect product_id, min(year) as first_year  \nfrom sales \ngroup by product_id \n) as a \non s.product_id = a.product_id and s.year = a.first_year
[]