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

ORacle sql
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 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!