Question

Write the SQL commands to answer the queries based on Fabric table

Fabric ID	Fname	Type	Disc
F001	Shirt	Woollen	10
F002	Suit	Cotton	20
F003	Tunic	Cotton	10
F004	Jeans	Denim	5
F005	Shorts	Cotton	7

a. To insert the following record 

(“F005”, “Kurta”, “Woollen”,5) 

b. To display only those fabric whose disc is more than 10 

c. To display those records whose type is “Woollen” 

d. To modify the fabric shirt by increasing discount by 10 

e. To delete the record of fabric ‘F003’ from table

Answer 1

Fabric ID	Fname	Type	Disc
F001	Shirt	Woollen	10
F002	Suit	Cotton	20
F003	Tunic	Cotton	10
F004	Jeans	Denim	5
F005	Shorts	Cotton	7

a. insert into Fabric values (‘F005’, ‘Kurta’, ‘Woollen’,5);

b. select * from Fabric where Disc>10;

c. select * from Fabric where type = ‘Woollen’;

d. update fabric 

set Disc = Disc + 10 

where name = ‘Shirt’;

e. delete from Fabric where FabricID =‘F003’;