Question: What is "group by"?

Solution: GROUP BY is a way by which we tell the DBMS, to group the retrieved records based on one or more columns so that an aggregate function can be performed on every group of rows.