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

Answer 1

SELECT

list_price,

discount_percent,

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

FROM

Products;

Step-by-step explanation: