Structure of the CUSTOMERS Table

Multiple Choice

Structure of the CUSTOMERS table
​
Structure of the ORDERS table
Structure of the ORDERITEMS table
Structure of the BOOKS table
-Which of the following SQL statements will display books that have not been ordered recently?​

A) ​SELECT title
FROM books,orderitems
WHERE books.isbn <> orderitems.isbn;
B) ​SELECT title
FROM books NATURAL JOIN orderitems
WHERE JOIN IS NULL;
C) ​SELECT title FROM books NATURAL JOIN orderitems
MINUS
SELECT title FROM books;
D) ​SELECT title FROM books
MINUS
SELECT title FROM books NATURAL JOIN orderitems;