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);

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 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);

Quizplus · Accepted Answer

In order to retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00, we need to use the logical operator AND to combine the condition of category and retail price. Therefore, option C is the correct query as it uses parenthesis to group the category conditions together and then applies the retail price condition to them. Option A is incorrect because it uses 'OR' instead of 'AND' which will retrieve all books that are either in the BUSINESS category or have a retail price greater than $35.00. Option B is incorrect because it does not group the category conditions together and it will retrieve all books that are either in the BUSINESS category or have a retail price greater than $35.00. Option D is incorrect because it uses parenthesis to group the retail price condition instead of the category conditions, which means it will retrieve all books that either have a retail price greater than $35.00 or are in the COMPUTER category.

Contents of BOOKS Table