Question

Write the SQL commands to answer the queries based on Fabric table
FabricID Fname Type Disc F001 Shirt Woollen 10 F002 Suit Cotton 20 F003 Tunic Cotton 10 F004 Jeans Denim 5 F006 Shorts Cotton 7

Answer 1

FOR SELECT :-

SELECT*FROM FABRIC

Answer 2

Answer:

A) INSERT INTO TABLE NAME ( FabricID, Fname, Type, Disc)

  VALUES ( 'F005', 'Kurta', 'Woolen', '5') ;

B) SELECT * FROM TABLE NAME

  WHERE  Disc > 10;

C) SELECT * FROM TABLE NAME

   WHERE  Type = 'Woolen';

D) UPDATE TABLE NAME

   SET Disc = 20

    WHERE Fname = 'Shirt';

E) DELETE * FROM TABLE NAME

  WHERE FabricID = 'F003';

Explanation: