HR 1

SELECT em.first_name, em.salary
FROM employees em
JOIN departments d ON em.department_id = d.department_id
JOIN locations l ON d.location_id = l.location_id
JOIN countries con ON l.country_id = con.country_id
WHERE em.job_id LIKE 'IT_%' AND con.country_id LIKE 'US';