154.View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.

154.View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.
Evaluate the following SQL statement:


SQL>SELECT prod_id FROM products
INTERSECT
SELECT prod_id FROM sales
MINUS
SELECT prod_id FROM costs;


Which statement is true regarding the above compound query?
A.It produces an error.
B.It shows products that were sold and have a cost recorded.
C.It shows products that were sold but have no cost recorded.
D.It shows products that have a cost recorded irrespective of sales.
答案：C
解析：参考前几道题的说明选择C