SQL oracle

QUESTION 12 Display (1) Department id, (2) Job id and the (3) Lowest salary for this combination but only if that Lowest Pay falls in the range $6000 - $18000 Exclude people who (a) work as some kind of Representative (REP)job from this query and (b) departments IT and SALES Sort the output according to the Department_id and then by Job id. You MUST NOT use the Subquery method. - 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