Contents of BOOKS table

-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit?
A) SELECT * FROM books WHERE profit .6;
B) SELECT * FROM books WHERE (retail-cost)/cost .60;
C) SELECT * FROM books WHERE (retail-cost)/cost 60%;
D) SELECT * FROM books WHERE (retail-cost)/cost '60';

Question

Contents of BOOKS table
  ​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit?​
A) ​SELECT * FROM books WHERE profit > .6; 
B) ​SELECT * FROM books WHERE (retail-cost)/cost > .60; 
C) ​SELECT * FROM books WHERE (retail-cost)/cost > 60%; 
D) ​SELECT * FROM books WHERE (retail-cost)/cost > '60';

Quizplus · Accepted Answer

The query in option B calculates the profit margin percentage by subtracting the cost from the retail price and dividing that amount by the cost. Then it checks if that percentage is greater than 0.60 (60%). This will show all books that generate more than 60% profit. Option A compares the profit amount to 0.6 which would not account for differences in book costs. Option C uses incorrect syntax for the percentage value. Option D compares the profit margin to a string value rather than a numerical value.

Contents of BOOKS Table