Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL query Question 2: Write an equivalent query for the following query SELECT orderid FROM ORDERS WHERE customerid IN (SELECT customerid FROM CUSTOMERS WHERE city='So

SQL query

image text in transcribed

Question 2: Write an equivalent query for the following query SELECT orderid FROM ORDERS WHERE customerid IN (SELECT customerid FROM CUSTOMERS WHERE city='So Paulo' ) OR orderid in (SELECT orderid FROM ORDERDETAILS, SUPPLIERS,PRODUCTS WHERE ORDERDETAILS.productid=PRODUCTS.productid AND PRODUCTS.supplierid=SUPPLIERS.supplierid AND city='So Paulo')

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

Oracle 10g SQL

Authors: Joan Casteel, Lannes Morris Murphy

1st Edition

ISBN: 141883629X, 9781418836290

More Books

Students also viewed these Databases questions

Question

Know how to use reservations systems to inventory demand.

Answered: 1 week ago