Contents of BOOKS Table

Multiple Choice

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