Q18. Write the SQL command for the following on the basis of given table. Table : FURNITURE
PRICE
NO ITEMNAME TYPE DATEOFSTOCK
DISCOUNT
(%)
23/02/2002
30000
Bouble bed
1
25
White lotus
20/01/2003
20
Pink feather
7000
2
Baby cot
Baby cot
3
Dolphin
20
19/02/2003
9500
Decent
Office Table
01/01/2002
25000
30
Comfort zone
5
Double bed
12/01/2002
25000
25
Donald
6
Baby cot
24/02/2002
6500
15
i. To display itemnames bought in the year 2003.
ii. To increase the discount by 5% for items where price is in the range of 5000
and 10000
To delete all those records where the itemname starts with D and ends with n.
iv. Add a field by the name quan_in_hand to store the number of items for every item.
v. Select min(dateofstock) from furniture;
vi. Select sum(price) from furniture where discount IN ( 20,30);​