Question: ORacle sql QUESTION 10 Show what customers (1) number and (2) name along with the (3) country name for all customers that are in the




QUESTION 10 Show what customers (1) number and (2) name along with the (3) country name for all customers that are in the same countries as the Supra customers. Limit the list to any customer names that starts with the letters A to C. - Tables (Filtered) -- COUNTRIES - COUNTRY_ID COUNTRY_NAME REGION_ID B CUSTOMERS 1 CUST_NO CNAME STATUS CUST_TYPE -D COUNTRY_CD BRANCH_CD ADDRESS1 ADDRESS2 I CITY PROV_STATE POST_ZIP - PHONE_NO FAX_NO I CONTACT SALES_REP - DEPARTMENTS - EMPLOYEES - - DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID EMPLOYEES 1 EMPLOYEE_ID FIRST NAME LAST_NAME 1 EMAIL PHONE NUMBER HIRE_DATE JOB_ID 1 SALARY 1 COMMISSION_PCT 1 MANAGER_ID DEPARTMENT_ID JOB_GRADES U GRADE 1 LOWEST_SAL II HIGHEST_SAL JOB_HISTORY EMPLOYEE_ID START_DATE 6- TTTTTTTTTTTT 6- JOB_HISTORY " EMPLOYEE_ID O START_DATE END_DATE JOB_ID 11 DEPARTMENT_ID 6-0 LOCATIONS LOCATION_ID STREET_ADDRESS POSTAL_CODE I CITY STATEPROVINCE 10 COUNTRY_ID ORDERLINES ORDER_NO LINE_NO PROD_NO PRICE 0 QTY DISC_PERC E ORDERS 11 ORDER_NO - REP_NO I CUST_NO I DISC_PERC ORDERS ORDER_NO REP_NO CUST_NO ORDER_DT STATUS V CHANNEL E PRODUCTS 1 PROD_NO I PROD_LINE - PROD_TYPE PROD_NAME I PROD_COST PROD_SELL STATUS PICTURE SALES_2016 SALES_2015 SALES_2014 SALES_2013 SID SUPPLIERS Loading
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
