Question

28. Write SQL commands for (i) to (v) and write the output for (vi) on the basis of the following table
Table: FURNITURE
S NO ITEM
TYPE
DATEOFSTOCK PRICE DISCOUNT
1 WhiteLotus DoubleBed 2002-02-23
3000 25
2 Pinkfeathers Baby Cot 2002-01-29
7000 20
3 Dolphin
Baby Cot 2002-02-19
9500 20
4
Decent
Office Table 2002-02-01
25000 30
Comfortzone Double Bed 2002-02-12
25000 30
6 Donald
Baby Cot 2002-02-24
6500 15
N
5
(i) To list the details of furniture whose price is more than 10000.
(ii) To list the Item name and Price of furniture whose discount is between 10 and 20.
(iii) To delete the record of all items where discount is 30.
(iv) To display the price of 'Babycot'.
(v) Select Distinct Type from Furniture;​

Answer 1

Answer:

(i) To list the details of furniture whose price is more than 10000.

Answer 2

i ) Select*from furniture where price >10000;

ii ) Select name,price from furniture where discount between 10 and 20;

iii) Delete from student where discount= 30;

iv) Select price from Furniture where type = 'Babycot' ;

v) output = Office table