SELECT ALL LOCATIONS.CITY, COUNTRIES.COUNTRY_NAME,
DEPARTMENTS.DEPARTMENT_NAME, COUNT(EMPLOYEES.EMPLOYEE_ID)
FROM DEPARTMENTS, COUNTRIES, LOCATIONS, EMPLOYEES
WHERE (DEPARTMENTS.LOCATION_ID = LOCATIONS.LOCATION_ID)
AND (LOCATIONS.COUNTRY_ID = COUNTRIES.COUNTRY_ID)
AND (EMPLOYEES.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID)
GROUP BY(LOCATIONS.CITY, COUNTRIES.COUNTRY_NAME,
DEPARTMENTS.DEPARTMENT_NAME )