Write a SELECT statement that returns these columns from the Products table: The list_price column The discount_percent column A

Question

3 years ago

6

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

Computers and Technology

1 answer:

MA_775_DIABLO [31] · Answer 1 · 2022-06-23T21:09:36+03:00

MA_775_DIABLO [31]3 years ago

6 0

Answer:

SELECT

list_price,

discount_percent,

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

FROM

Products;

Explanation: