Question

3. a) The structure of a table "ITEM" is given below.
Suggest suitable data type and size of each column.
Column name Type
Size
Item no
Iname
Price
Quantity
b) Consider the following table "ITEM":
Table: Item
Itemno
Iname
Price Quantity
11
Soap
40
80
22
Powder 80
30
33
Face cream 250
25
44
Shampoo 120
100
55
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:

Explanation:

I hope that it would help you and mark me as the brainiest please

Answer 2

Answer:

this is answer

Explanation:

hope it helps you

please mark me as brainliest