Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following
SQL statements would create an intersection of the two relations with the widest variety of
Structured Query Language dialects?

A.
SELECT *
FROM Dept1_Parts
AND
(SELECT *
FROM Dept2_Parts);

B.
SELECT *
FROM Dept1_Parts
INTERSECTION
(SELECT *
FROM Dept2_Parts);

C.
SELECT *
FROM Dept1_Parts
WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

D.
SELECT *
FROM Dept1_Parts
WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;