Question

4. Consider the following table "ITEM":

Table: Item

Itemno

11

22

33

44

Price

40

80

250

120

[3 Marks]

Quantity

80

30

25

100

Iname

Soap

Powder

Face cream

Shampoo

i. Display 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.

iii. To insert a new record(55, 'Soapbox',20,50)​

Answer 1

Answer:

powder powder powder powder powder and salt

Answer 2

Answer:

a) Select price * quantity from item;

b)Select * from item where price < 50;

Explanation:

hope it helps

Mark as brainless if it does