convert above table to below talbe in sql query

 StudentID Mark

1 10

1 20

1 30

2 40

2 50

2 60

3 70

3 80

3 90

StudentIDS Marks

1 10,20,30

2 40,50,60

3 70,80,90

convert above table to below talbe in sql query

SELECT StudentID, GROUP_CONCAT(Mark) AS Marks

FROM original_table

GROUP BY StudentID;