Contents of BOOKS Table

question 38

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