group by with avg function

SQL GROUP BY Statement  is used to arrange identical data into groups with the help of Aggregate functions.