I need example code in MYSQL:

1. Define a view named SCRIBNER. It consists of the book code, title, type, and price for every book published by the publisher whose code is SC.

a. Write and execute the CREATE VIEW command to create the SCRIBNER view.

b. Write and execute the command to retrieve the book code, title, and price for every book with a price of less than $15.

c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so,

what are they? If not, why not?

2. Define a view named NONPAPERBACK. It consists of the book code, title, publisher name, and price for every book that is not available in paperback.

a. Write and execute the CREATE VIEW command to create the NONPAPERBACK view.

b. Write and execute the command to retrieve the book title, publisher name, and price for every book in the NONPAPERBACK view with a price of less than $20.

c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so,

what are they? If not, why not?