Display $(1)$ last$\_$name, $(2)$ salary and $(3)$ job for all employees who earn more than all lowest paid employees in departments 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. $($USING$/$JOIN or ON$)$ Oracle SQL Developer File Edit View Navigate Run Source Team $)61\%(4)$ Fri $12$:$49$ PM Tools Window Help Oracle SQL Developer : Welcome Page $14.$ SOL ba Welcome Page C DBS$311$ ORDERLINES Version: $19\mathrm{.}2\mathrm{.}1\mathrm{.}247\mathrm{.}2212$ ORACLE SQL Developer New Version Available! $19\mathrm{.}4$ Database Connection Getting Started Recent Databases Detected Get a Database Information Tutorials Demos Training DBS$311$ Oracle VirtualBox Appliance Docker Images DBS$211$ Oracle Database XE Connections $+62$ Y $33$ ED EMPLOYEES $1$ EMPLOYEE$\_$ID $1$ FIRST$\_$NAME $-$ LAST$\_$NAME $1$ EMAIL O PHONE$\_$NUMBER O HIRE$\_$DATE I JOB$\_$ID $1$ SALARY $1$ COMMISSION$\_$PCT MANAGER$\_$ID $1$ DEPARTMENT$\_$ID $60$ JOB$\_$GRADES I GRADE LOWEST$\_$SAL HIGHEST$\_$SAL $0$ JOB$\_$HISTORY $-$ EMPLOYEE$\_$ID START$\_$DATE $-$ END$\_$DATE JOB$\_$ID I DEPARTMENT$\_$ID $60$ LOCATIONS LOCATION$\_$ID $-$ STREET$\_$ADDRESS O POSTAL CODE I CITY D STATE$\_$PROVINCE $0$ COUNTRY$\_$ID $0$ ORDERLINES H ORDER$\_$NO LINE$\_$NO PROD$\_$NO O PRICE I QTY Create a Connection Manually Resources Related Tools Community Extensions Modeler $-$ Data modeling and database design SQLcl $-$ The power of SQL Developer in a CLI SQL Developer Exchange SQL Developer Forum Oracle Live SQL $-$ Learn and share SQL$,$ for free. Team Blogs and Magazine Articles ORDS $-$ REST Enable the Oracle Database Follow Us$!$ Messages $-$ Log Breakpoints IVICssayes Jualemens Reports $$Oracle SQL Developer File Edit View Navigate Run Source Team $1)61\%(4)$ Fri $12$:$49$ PM Tools Window Help Oracle SQL Developer : Welcome Page $14.$ SOL ba Welcome Page C DBS$311$ ORDERLINES Version: $19\mathrm{.}2\mathrm{.}1\mathrm{.}247\mathrm{.}2212$ ORACLE SQL Developer New Version Available! $19\mathrm{.}4$ Database Connection Getting Started Recent Databases Detected Get a Database Information Tutorials Demos Training DBS$311$ Oracle VirtualBox Appliance Docker Images DBS$211$ Oracle Database XE Connections $+$ HY $!$ CD ORDERLINES $0$ ORDER$\_$NO LINE$\_$NO $1$ PROD$\_$NO I PRICE HI QTY O DISC$\_$PERC $60$ ORDERS $-$ ORDER$\_$NO I REP$\_$NO $1$ CUST$\_$NO $0$ ORDER$\_$DT O STATUS H CHANNEL O PRODUCTS O PROD$\_$NO PROD$\_$LINE I PROD$\_$TYPE PROD$\_$NAME $0$ PROD$\_$COST PROD$\_$SELL O STATUS $1$ PICTURE $1$ SALES$\_2016$ O SALES$\_2015$ O SALES$\_2014$ O SALES$\_2013-$ SID SUPPLIERS I SUP$\_$NO $-$ SUP$\_$NAME I STREET I CITY BPOST$\_$ZIP $-$ REP$\_$NAME Create a Connection Manually Resources Related Tools Community Extensions Modeler $-$ Data modeling and database design SQLcl $-$ The power of SQL Developer in a CLI SQL Developer Exchange SQL Developer Forum Oracle Live SQL $-$ Learn and share SQL$,$ for free. Team Blogs and Magazine Articles ORDS $-$ REST Enable the Oracle Database Follow Us$!$ Messages $-$ Log Breakpoints IVICssayes Jualemens Reports $$Oracle SQL Developer File Edit View Navigate Run Source Team $61\%[4]$ Fri $12$:$49$ PM Tools Window Help Oracle SQL Developer : Welcome Page $.$ SOL ba Connections Welcome Page C DBS$311$ ORDERLINES Version: $19\mathrm{.}2\mathrm{.}1\mathrm{.}247\mathrm{.}2212$ ORACLE SQL Developer New Version Available! $19\mathrm{.}4$ Database Connection Getting Started Recent Databases Detected Get a Database Information Tutorials Demos Training DBS$311$ Oracle VirtualBox Appliance Docker Images DBS$211$ Oracle Database XE Tables $($Filtered$)$ GO COUNTRIES I COUNTRY$\_$ID $0$ COUNTRY$\_$NAME $-$ REGION$\_$ID U CUSTOMERS U CUST$\_$NO $1$ CNAME $1$ STATUS $1$ CUST$\_$TYPE $1$ COUNTRY CD BRANCH$\_$CD ADDRESS$11$ ADDRESS I CITY O PROV$\_$STATE I POST$\_$ZIP O PHONE$\_$NO $0$ FAX$\_$NO $11$ CONTACT $1$ SALES$\_$REP E DEPARTMENTS DEPARTMENT$\_$ID DEPARTMENT$\_$NAME MANAGER$\_$ID LOCATION$\_$ID ED EMPLOYEES EMPLOYEE$\_$ID $*$ FIRST$\_$NAME $1$ LAST$\_$NAME I EMAIL O PHONE$\_$NUMBER HIRE$\_$DATE JOB$\_$ID $-$ SALARY Create a Connection Manually Resources Related Tools Community Extensions Modeler $-$ Data modeling and database design SQLcl $-$ The power of SQL Developer in a CLI SQL Developer Exchange SQL Developer Forum Oracle Live SQL $-$ Learn and share SQL$,$ for free. Team Blogs and Magazine Articles ORDS $-$ REST Enable the Oracle Database Follow Us$!$ Messages $-$ Log Breakpoints IVICssayes Jualemens Reports $$