using where clause in group by

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