Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications Dexa 2021 Workshops Biokdd Iwcfs Mlkgraphs Al Cares Protime Alsys 2021 Virtual Event September 27 30 2021 Proceedings

Authors: Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil ,Bernhard Moser ,Atif Mashkoor ,Johannes Sametinger ,Anna Fensel ,Jorge Martinez-Gil ,Lukas Fischer

1st Edition

3030871002, 978-3030871000

More Books

Students also viewed these Databases questions

Question

Explain exothermic and endothermic reactions with examples

Answered: 1 week ago

Question

Consistently develop management talent.

Answered: 1 week ago

Question

Create a refreshed and common vision and values across Europe.

Answered: 1 week ago

Question

Provide the best employee relations environment.

Answered: 1 week ago