Which of the following queries determines which customers have ordered the same books as customer 1017?
a. SELECT order# FROM orders

WHERE customer# = 1017;

b. SELECT customer# FROM orders

JOIN orderitems USING (order#)
WHERE isbn = (SELECT isbn FROM orderitems
WHERE customer# = 1017);

c. SELECT customer# FROM orders

WHERE order# = (SELECT order# FROM orderitems
WHERE customer# = 1017);

d. SELECT customer# FROM orders

JOIN orderitems USING (order#)
WHERE isbn IN (SELECT isbn FROM orderitems
JOIN orders USING (order#)
WHERE customer# = 1017);