SQL using GROUP BY .

 Table which is used for  GROUP BY :-

1.  select MIN(score) AS 'total' from test1 GROUP BY id

2.  select COUNT(score) AS 'total' from test1 GROUP BY id

3.  select SUM(score) AS 'total' from test1 GROUP BY id

4. select MAX(score) AS 'total' from test1 GROUP BY id