Solved

Contents of BOOKS Table

Question 55

Multiple Choice

Contents of BOOKS table
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';
-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';

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions