Computer Science - Class 12
Solutions to CBSE Sample Paper - Computer Science Class 12

(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:

Answer by student

The SQL statement is:

SELECT Name, Price * (1 - Discount) AS ‘Final Price’ FROM Product WHERE Discount IS NOT NULL;

Detailed answer by teachoo

The rest of the post is locked. Join Teachoo Black to see the full post.

Go Ad-free
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.