SELECT *
FROM (
    SELECT *
    FROM locations loc
    JOIN departments dep
    ON dep.location_id = loc.location_id
    JOIN (SELECT first_name, last_name, location_id, salary
        FROM (
        SELECT *
        FROM departments dep
        JOIN employees emp
        ON emp.department_id = dep.department_id)
        )
        ON dep.location_id = loc.location_id)