Hello , I would be happy if someone could check my sql queries. I currently don't have an environment where I can run them, but I have a database schema.
SELECT COUNT HR.EMPLOYEES
FROM HR.DEPARTMENS
JOIN HR.EMPLOYEES
ON HR.EMPLOYEES.DEPARTMENT_ID = HR.DEPARTMENS.DEPARTMENT_ID
JOIN HR.DEPARTMENTS
ON HR.DEPARTMENTS.LOCATIONS_ID = HR.LOCATIONS.LOCATION_ID
JOIN HR.LOCATIONS
ON HR.LOCATIONS.COUNTRY_ID = HR.COUNTRIES.COUNTRY_ID
WHERE HR.COUNTRIES.COUNTRY_NAME IS NOT US
SELECT HR.EMPLOYEES.FIRSTNAME, HR.EMPLOYEES.LASTNAME
FROM HR.EMPLOYEES
JOIN HR.JOBS
ON HR.JOBS.JOB_ID = HR.EMPLOYEES.JOB_ID
ORDER BY HR.JOBS.MAX_SALARY DESC
LIMIT 1
SELECT HR.EMPLOYEES.FIRSTNAME, HR.EMPLOYEES.LASTNAME
FROM HR.EMPLOYEES
JOIN HR.JOBS_HISTORY
ON HR.EMPLOYEES.JOB_ID = HR.JOBS_HISTORY.JOB.ID
WHERE HR.JOBS_HISTORY.START_DATE > 2003 AND HR.JOBS_HISTORY.END_DATE < 2007
Thank you so much