http://w3schools.i2p/sql/sql_ref_group_by.asp
The following SQL lists the number of customers in each country: Example SELECT COUNT(CustomerID), Country FROM Customers GROUP BY Country; Try it Yourself » The following SQL lists the number of customers in each country, sorted high to low: Example SELECT COUNT(CustomerID), Country FROM Customers GROUP BY Country ORDER BY COUNT(CustomerID) DESC; Try it Yourself » ❮ Previous ❮ SQL Keywords Reference Next ❯ COLOR PICKER Get certified by completing a course today!