GROUP BY SQL Statement
The GROUP BY statement summarises rows with the same values, such as “find the number of customers in each country.” To group the result-set by one or more columns, the GROUP BY statement is frequently used with aggregate functions (COUNT(), MAX(), MIN(), SUM(), AVG()).