Question

write the SQL commands to answer the queries based on the fabric table:FabID Fname. Type. Disc F01. SHIRT. WOOLEN. 10 F02. SUIT. COTTON. 20F03. TUNIC. COTTON. 10F04. JEANS. DENIM. 5a) to insert the following record ("F005" , "kurta" , " woolen,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) delete the record of fabric F003 from table. ( IT vocational ) please write the answer in the correct way......

Answer 1

A) INSERT INTO TABLENAME (FabricID, Fname, Type, Disc)

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

B) SELECT * FROM TABLENAME

     WHERE Disc >10;

C) SELECT * FROM TABLENAME

      WHERE TYPE = 'Woolen';

D) UPDATE TABLENAME

    SET Disc = '20'

    WHERE Fname = 'Shirt';

E) DELETE * FROM TABLENAME

   WHERE FabricID = 'F003';