Write a SELECT statement that returns these columns from the

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.

Please write as you will write in SQL software

Solution

Let the Products table contain PRODUCT_ID, PRODUCT_CODE, PRODUCT_NAME, PRODUCT_DESCRIPTION, LIST_PRICE, DISCOUNT_PERCENTAGE, ADDED_DATE

SELECT Product_Id, Product_code, Product_Name, Product_Description, List_Price, Discount_Percentage, Added_Date, (List_Price * Discount_Percentage) / 100 AS Discount_Amount FROM Products_Table