The publisher with code LB has decreased the price of its fiction books by four percent. Update the prices in the FICTION table accordingly.

 

 

Assignment 3 – Chapter 6InstrucTons:Add your SQL statement and results (using screen captures) to each quesTon.Do NO±remove any exisTng content or images from this Fle.1.Create a FICTION table with structure shown inFigure 6-29.FIGURE 6-29:FICTION table layoutHint:The FICTION table is similar to the BOOK table that is part of the HenryBooks database.The SQL statement used to create the BOOK table is shownbelow.Model your “CREATE TABLE FICTION”SQL command after it.Di±erences between the BOOK and FICTION tables are:The PUBLISHER_CODE attribute for the FICTION table is CHAR(3)There is no TYPE attribute and there is no PAPERBACK attribute in theFICTION table.Put your SQL command and results here:2.Insert into the FICTION table the book code, book title, publisher code,and price from the BOOK table for only those books having type FIC.