🚀 Simplest Solution Using Rank  👍✨
\n# Code author Naveen Kumar Vadlamudi \n# Simplest Solution Using Rank..\n# Upvote if it helps \uD83D\uDC4D\n\nSELECT \nA.PRODUCT_ID,\nA.YEAR AS FIRST_YEAR,\nA
```\n# Code author Naveen Kumar Vadlamudi \n# Simplest Solution Using Rank..\n# Upvote if it helps \uD83D\uDC4D\n\nSELECT \nA.PRODUCT_ID,\nA.YEAR AS FIRST_YEAR,\nA.QUANTITY,\nA.PRICE\nFROM\n(\n    SELECT  *,\n    DENSE_RANK() OVER(PARTITION BY PRODUCT_ID ORDER BY YEAR) AS CRANK\n    FROM SALES\n) A\nWHERE A.CRANK = 1 \n\n```
['MySQL']