What is "group-by"

The command GROUP BY is used in conjunction with the group aggregation functions by one or more columns result set.

Syntax

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name

Source