write the SQL commands to answer the queries based on fabric table:__________________________FabID- Fname- Type- Disc--------------------------------------------------F01. shirt. woolen. 10-------------------------------------------------F02. suit. cotton. 20-------------------------------------------------F03. tunic. cotton. 10-------------------------------------------------F04. jeans. denim. 5 __________________________ a) to insert the following record ("F005", "Kurta", " woollen" ,5 )b) to display only those fabric who disc is more than 10)c) to display those record whose type is "woolen".d) to modify the fabric shirt by increasing the discount of 10.e) to delete the record of fabric F003 from the table.(IT vocational) please answer this question correctly.......
Answers
write the SQL commands to answer the queries based on fabric table:__________________________FabID- Fname- Type- Disc--------------------------------------------------F01. shirt. woolen. 10-------------------------------------------------F02. suit. cotton. 20-------------------------------------------------F03. tunic. cotton. 10-------------------------------------------------F04. jeans. denim. 5 __________________________ a) to insert the following record ("F005", "Kurta", " woollen" ,5 )b) to display only those fabric who disc is more than 10)c) to display those record whose type is "woolen".d) to modify the fabric shirt by increasing the discount of 10.e) to delete the record of fabric F003 from the table.(IT vocational) please answer this question correctly.......