SELECT first_name||' '||last_name AS "NAME", SALARY, JOBS.JOB_TITLE AS "JOB TITLE" FROM EMPLOYEES
    INNER JOIN JOBS ON  EMPLOYEES.JOB_ID=JOBS.JOB_ID
    INNER JOIN DEPARTMENTS ON EMPLOYEES.DEPARTMENT_ID=DEPARTMENTS.DEPARTMENT_ID
    INNER JOIN LOCATIONS ON DEPARTMENTS.LOCATION_ID=LOCATIONS.LOCATION_ID
    INNER JOIN COUNTRIES ON COUNTRIES.COUNTRY_ID=LOCATIONS.COUNTRY_ID
    WHERE DEPARTMENTS.DEPARTMENT_NAME LIKE'IT%' AND COUNTRIES.COUNTRY_ID = 'US';