Question

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

FabricID Fname Type Disc

F001 Shirt Wollen 10

F002 Suit Cotton 20

F003 Tunic Cotton 10

F004 Jeans Denim 5

F006 Shorts Cotton 7

a) To insert the following record

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

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

c) To display those record whose type is “Wollen”

d) To modify the fabric shirt by increasing discount of 10

e) To delete the record of fabric F003 from table​

Answer 1

Dear friend, The answer is given in the attachment. I hope it helps you!

Pls mark the brainliest!