Question

What is wrong with the following query?

select firstname
     , lastname
from Customer
intersect
select productid
     , price
     , quantity
from order_detail join orders
     on order_detail.orderid = orders.orderid;

Group of answer choices

1 Nothing is wrong with this query

2 When working with set operators both queries have to contain the same number of columns.

3 The wrong set operator is being used. This query should use EXCEPT.

4 The wrong set operator is being used. This query should use UNION.

Answer 1

$\small \color{blue}Answer:\;\;$

set operators both queries have to contain the same number of columns. The corresponding columns in the queries that make up a compound query must be of the same data type group.

Answer: 2