select count(student.ID), country.COUNTRYNAME
from student
INNER JOIN COUNTRY
ON student.ID = COUNTRY.ID
GROUP BY COUNTRYNAME