sql count by column value code example

Example 1: sql groub by count

SELECT COUNT(Id), Country 
  FROM Customer
 GROUP BY Country

Example 2: count occurrences sql

SELECT age, count(age) 
  FROM Students 
 GROUP by age