count certain text sql code example Example: count occurrences sql SELECT age, count(age) FROM Students GROUP by age