GROUP BY AND HAVING
GROUP BY:
Using group by, we can create groups of related information.
Columns used in select must be used with group by, otherwise it was not a group by expression
HAVING:
This will work as where clause which can be used only with group by because of absence of where clause in group by.