Syntax of GROUP BY clause in SQL-

SELECT <column_name(s)>

FROM <table_name>

WHERE<condition>

GROUP BY<column_name(s)>;

Example of GROUP BY clause in SQL-

SELECT COUNT (CustomerID), Country

FROM Customers

GROUP BY Country;

–This SQL statement will list the number of customers in each country.