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;