MySQL | GROUP BY
\n\n# Code\nmysql []\n# Write your MySQL query statement below\nSELECT PRODUCT_ID, YEAR AS FIRST_YEAR, QUANTITY, PRICE FROM SALES\nWHERE (PRODUCT_ID, YEAR) IN \
\n\n# Code\n```mysql []\n# Write your MySQL query statement below\nSELECT PRODUCT_ID, YEAR AS FIRST_YEAR, QUANTITY, PRICE FROM SALES\nWHERE (PRODUCT_ID, YEAR) IN \n(SELECT PRODUCT_ID, MIN(YEAR) AS YEAR FROM SALES \nGROUP BY PRODUCT_ID); \n```
['MySQL']