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;

Question

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;

Quizplus · Accepted Answer

The query in option D will select all the books from the BOOKS table that are not present in the ORDERITEMS table, indicating that they have not been ordered recently. Options A and B join the BOOKS and the ORDERITEMS tables, which is not necessary to achieve the desired result. Option C uses the MINUS operator to select books from the BOOKS table that are not present in the BOOKS and ORDERITEMS tables together, which is not what we need.

Structure of the CUSTOMERS Table