Which of the following lists each book having a profit of at least $10.00 in descending order

Question:

Which of the following lists each book having a profit of at least $10.00 in descending order by profit?

a. SELECT * FROM books WHERE profit => 10.00

    ORDER BY "Profit" desc;

b. SELECT title, retail-cost "Profit" FROM books

WHERE profit => 10.00

ORDER BY "Profit" desc;

c. SELECT title, retail-cost "Profit" FROM books

WHERE "Profit" => 10.00

ORDER BY "Profit" desc;

d. SELECT title, retail-cost profit FROM books

WHERE retail-cost >= 10.00

ORDER BY "PROFIT" desc;

e. SELECT title, retail-cost "Profit" FROM books

WHERE profit => 10.00

ORDER BY 3 desc;

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: