Contents of BOOKS table

-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will return all books that cost at least $25.00?
A) SELECT * FROM books WHERE cost $25.00;
B) SELECT * FROM books WHERE cost = 25.00;
C) SELECT * FROM books WHERE cost = $25.00;
D) none of the above

Question

Contents of BOOKS table
  ​
-Based upon the contents of the BOOKS table in the accompanying figure,which of the following queries will return all books that cost at least $25.00?​
A) ​SELECT * FROM books WHERE cost > $25.00; 
B) ​SELECT * FROM books WHERE cost >= 25.00; 
C) ​SELECT * FROM books WHERE cost >= $25.00; 
D) ​none of the above

Quizplus · Accepted Answer

The correct syntax for comparing numeric values in SQL does not include the dollar sign. Therefore, the query that correctly returns all books costing at least $25.00 is "SELECT * FROM books WHERE cost >= 25.00;".

Contents of BOOKS Table