Question

Write a SELECT statement that returns these columns from the Products table: The list_price column The discount_percent column A column named discount_amount that uses the previous two columns to calculate the discount amount and uses the ROUND function to round the result so it has 2 decimal digits Use column aliases for any columns that contain a function or a formula.

Answer 1

Check the explanation

Step-by-step explanation:

The SELECT statement that returns these columns are:

SELECT

list_price,

discount_percent,

ROUND (list_price * discount_percent / 100,2) AS discount_amount

FROM

products;

----------------------------------------------------------------------