How to use GROUP BY Clause in SQL?

Question

It is used with SELECT statement to group the result of the executed query using the value specified in it. It matches the value with the column name in tables and groups the end result accordingly.

Syntax:

SELECT column_name(s)  FROM table_name  GROUP BY column_name;