Question

Q. 21
a) The structure of a table "ITEM" is given below. Suggest suitable data type and
size of each column.
Column name Type
Size
Itemno
Iname
Price
Quantity
b) Consider the following table "ITEM":
Table: Item
Itemnolname Price Quantity
11
Soap
40 80
22
Powder 80 30
33
Face cream 250 25
44
Shampoo 120 100
55
Soap box 20 50
Write queries to
i. Display the total amount of each item. The amount must be calculated as
the price multiplied by quantity for each item.
ii. Display the details of items whose price is less than 50.​

Answer 1

Answer:

(¡) select*from ITEM price * quantity

(¡¡) select*from ITEM where price<50