Question: What is the output of the following SQL statement? Select customerid, customername from customer _ t where customerid in ( select customerid from order _

What is the output of the following SQL statement? Select customerid, customername from customer_t where customerid in (select customerid from order_t where orderid in (select orderid from order_t 0 where exists (select * from orderline_t where productid=3 and orderid=0.orderid) and exists (select * from orderline_t where productid=4 and orderid=0. orderid)))Shows the customers ID and name for a customer who has ordered both product IDs 3 and 4 in the same order. Shows the customers ID and name for all the customers who have ordered both product IDs 3 and 4 in the same order. Shows the customers ID and name for all the customers who have ordered both product IDs 3 and 4. Shows the customers ID for all the customers who have ordered product IDs 3 or 4 in the same order.

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!