group by with where

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