Which of the Following Will Display All Books That Were

Multiple Choice

Which of the following will display all books that were published at least three years before they were ordered?

A) SELECT title
FROM customers NATURAL JOIN orders
NATURAL JOIN orderitems NATURAL JOIN books
WHERE orderdate - pubdate >= 3;
B) SELECT title,
FROM orders o, orderitems oi, books b
WHERE
C) isbn = oi.isbn AND oi.order# = o.order# AND (orderdate-pubdate) /365 >= 3;.
D) isbn = oi.isbn AND oi.order# = o.order# AND orderdate - pubdate >= 3;,
E) SELECT title.
FROM orders o, orderitems oi, books b
WHERE..