sql oracle

5 pc QUESTION 13 Display (1) last name, (2) salary and (3) job for all employees who cam more than all lowest paid employees per department outside the US locations Exclude President and Vice Presidents from this query. This question may be interpreted as ALL employees in the table that are lower, OR comparing those in the US to the lowest outside the US. Choose whichever you want. Sort the output by job title ascending You need to use a Subquery and Joining with the NEWER method GSING A N - Tables (Filtered) -- COUNTRIES - COUNTRY_ID 1 COUNTRY_NAME REGION_ID CUSTOMERS CUST_NO CNAME STATUS 1 CUST_TYPE - COUNTRY_CD BRANCH_CD ADDRESS1 D ADDRESS2 I CITY PROV_STATE POST_ZIP - PHONE_NO FAX_NO CONTACT 1 SALES_REP - DEPARTMENTS 60 EMPLOYEES 6- E DEPARTMENTS I DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID EMPLOYEES 1 EMPLOYEE_ID FIRST NAME LAST_NAME EMAIL IPHONE_NUMBER HIRE_DATE JOB_ID SALARY 1 COMMISSION_PCT 1 MANAGER_ID DEPARTMENT_ID JOB_GRADES GRADE 1 LOWEST_SAL HIGHEST_SAL JOB_HISTORY 1 EMPLOYEE_ID START_DATE E TTTTTTTTTTTTT 6- JOB_HISTORY " EMPLOYEE_ID O START_DATE END_DATE JOB_ID 1 DEPARTMENT_ID 6-0 LOCATIONS LOCATION_ID STREET_ADDRESS POSTAL_CODE D CITY STATE_PROVINCE 10 COUNTRY_ID ORDERLINES 0 ORDER_NO LINE_NO PROD_NO I PRICE 0 QTY DISC_PERC 0 ORDERS ID ORDER_NO - REP_NO LI CUST_NO I DISC_PERC ORDERS ORDER_NO REP_NO CUST_NO ORDER_DT U STATUS V CHANNEL DE PRODUCTS 1 PROD_NO 0 PROD_LINE - PROD_TYPE PROD_NAME I PROD_COST PROD_SELL STATUS PICTURE SALES_2016 SALES_2015 SALES_2014 SALES_2013 SID SUPPLIERS Loading... 5 pc QUESTION 13 Display (1) last name, (2) salary and (3) job for all employees who cam more than all lowest paid employees per department outside the US locations Exclude President and Vice Presidents from this query. This question may be interpreted as ALL employees in the table that are lower, OR comparing those in the US to the lowest outside the US. Choose whichever you want. Sort the output by job title ascending You need to use a Subquery and Joining with the NEWER method GSING A N - Tables (Filtered) -- COUNTRIES - COUNTRY_ID 1 COUNTRY_NAME REGION_ID CUSTOMERS CUST_NO CNAME STATUS 1 CUST_TYPE - COUNTRY_CD BRANCH_CD ADDRESS1 D ADDRESS2 I CITY PROV_STATE POST_ZIP - PHONE_NO FAX_NO CONTACT 1 SALES_REP - DEPARTMENTS 60 EMPLOYEES 6- E DEPARTMENTS I DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID EMPLOYEES 1 EMPLOYEE_ID FIRST NAME LAST_NAME EMAIL IPHONE_NUMBER HIRE_DATE JOB_ID SALARY 1 COMMISSION_PCT 1 MANAGER_ID DEPARTMENT_ID JOB_GRADES GRADE 1 LOWEST_SAL HIGHEST_SAL JOB_HISTORY 1 EMPLOYEE_ID START_DATE E TTTTTTTTTTTTT 6- JOB_HISTORY " EMPLOYEE_ID O START_DATE END_DATE JOB_ID 1 DEPARTMENT_ID 6-0 LOCATIONS LOCATION_ID STREET_ADDRESS POSTAL_CODE D CITY STATE_PROVINCE 10 COUNTRY_ID ORDERLINES 0 ORDER_NO LINE_NO PROD_NO I PRICE 0 QTY DISC_PERC 0 ORDERS ID ORDER_NO - REP_NO LI CUST_NO I DISC_PERC ORDERS ORDER_NO REP_NO CUST_NO ORDER_DT U STATUS V CHANNEL DE PRODUCTS 1 PROD_NO 0 PROD_LINE - PROD_TYPE PROD_NAME I PROD_COST PROD_SELL STATUS PICTURE SALES_2016 SALES_2015 SALES_2014 SALES_2013 SID SUPPLIERS Loading