SELECT country_name, COUNT(department_name)
FROM countries c, departments d,  locations l
WHERE c.country_id=l.country_id
AND d.location_id=l.location_id
GROUP BY country_name;