count occurrences of field in sql code example Example: count occurrences sql SELECT age, count(age) FROM Students GROUP by age