Show the department_name and corresponding country_name

SELECT d.DEPARTMENT_NAME,c.COUNTRY_NAME

 FROM departments AS d

    JOIN 

    locations AS l

    ON d.LOCATION_ID=l.LOCATION_ID

 

    JOIN

    countries AS c 

    ON c.COUNTRY_ID = l.COUNTRY_ID;