Write a SELECT statement that returns these column names and data from the Produ

Question

Write a SELECT statement that returns these column names and data from the Products table: product_name The product_name column list_price The list_price column discount_percent The discount_percent column discount_amount A column that’s calculated from the previous two columns discount_price A column that’s calculated from the previous three columns Use the ROWNUM pseudo column so the result set contains only the first 5 rows. Sort the result set by discount price in descending sequence. In ORACLE

Explanation / Answer

SELECT

product_name , list_price , discount_percent , list_price*discount_percent/100 as "discount_ price"

FROM Products

WHERE ROWNUM < 6

ORDER BY "discount_price" DESC;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.