Question

Write output 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

select iname,price*quantity from item;

Answer 1

Output:

Iname	Price × Quantity
Soap	5000
Powder	5000
Face cream	3750
Pen	10000
Soap box	2000