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 book titles that are in the Business or Computer category and have a retail price of more than $35.00?

A) ​SELECT title FROM books
WHERE category = 'BUSINESS' OR 'COMPUTER' AND retail >35;
B) ​SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND retail >35;
C) ​SELECT title FROM books
WHERE (category = 'BUSINESS' OR category ='COMPUTER' ) AND retail >35;
D) ​SELECT title FROM books
WHERE category = 'BUSINESS' OR category ='COMPUTER' AND (retail >35) ;