A conditional statement similar to
WHERE but used with aggregate functions (
To return a result set of the number (count) of students from each country if the total number is less than 25:
SELECT COUNT(student_name),birth_countryFROM studentsGROUP BY birth_countryHAVING COUNT(student_name) < 25;
Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.
- Anonymous contributors
Learn SQL on Codecademy
- Anonymous contributorsAnonymous contributors