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

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;

Step by Step Solution

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

d SELECT title ret... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12126fcc_716424.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12126fcc_716424.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!