153.View the Exhibits and examine the structures of the PRODUCTS and SALES tables.

153.View the Exhibits and examine the structures of the PRODUCTS and SALES tables.
Which two SQL statements would give the same output? (Choose two.) 
A.SELECT prod_id FROM products
INTERSECT
SELECT prod_id FROM sales;
B.SELECT prod_id FROM products
MINUS
SELECT prod_id FROM sales;
C.SELECT DISTINCT p.prod_id
FROM products p JOIN sales s
ON p.prod_id=s.prod_id;
D.SELECT DISTINCT p.prod_id
FROM products p JOIN sales s
ON p.prod_id <> s.prod_id;
答案：AC
解析：a和b肯定是互斥的，c是两个表的inner join，相当于A，ac是一样的,
b这个如果不加DISTINCT的话，相当于两个表的笛卡尔连接，然后排除掉自己，差不多每个都有，然后再加一个DISTINCT的话，
基本就和只读products表一样