(ii) Display Name and Final Price (product of Price and (1-Discount)) of all products whose discount is known. The column heading ‘Final Price’ should also be displayed.
Answer by student
The SQL statement is:
SELECT Name, Price * (1 - Discount) AS ‘Final Price’ FROM Product WHERE Discount IS NOT NULL;