SELECT e.FIRST_NAME,c.COUNTRY_NAME
FROM employees AS e
JOIN
departments AS d
ON e.DEPARTMENT_ID = d.DEPARTMENT_ID
JOIN
locations AS l
ON d.LOCATION_ID= l.LOCATION_ID
JOIN
countries AS c
ON c.COUNTRY_ID = l.COUNTRY_ID;
Add your comment