Question

Write query based upon item table given.

Itemno	Iname	Price	Quantity
101	Soap	50	100
102	Powder	100	50
103	Face cream	150	25
104	Pen	50	200
105	Soap box	20	100

Display a report with item number, item name and total price. (total price = price * quantity).

Answer 1

SELECT Itemno, Iname, Price * Quantity AS TotalPrice FROM Item;