Contents of BOOKS table

-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?
A) SELECT * FROM books WHERE pubid = 1 OR pubid = 2 OR retail = 42;
B) SELECT * FROM books WHERE pubid IN (1,2)OR retail = 42;
C) SELECT * FROM books WHERE pubid = 1 AND pubid=2 OR retail =42;
D) both a and b

Question

Contents of BOOKS table
  ​
-​Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will retrieve all books stored in the BOOKS table with Pubid 1 or 2 or that have a retail price of at least $42.00?
A) ​SELECT * FROM books WHERE pubid = 1 OR pubid = 2 OR retail >= 42; 
B) ​SELECT * FROM books WHERE pubid IN (1,2)OR retail => 42; 
C) ​SELECT * FROM books WHERE pubid = 1 AND pubid=2 OR retail >=42; 
D) ​both a and b

Quizplus · Accepted Answer

Both options A and B correctly retrieve all books with a Pubid of 1 or 2 or that have a retail price of at least $42.00. Option A uses a combination of OR conditions, while option B uses the IN clause for Pubid and a correct comparison operator for the retail price.

Contents of BOOKS Table