Show me the steps to solve

Create SQL statements for the following.

$1.$ Database: books; add a new record to each of the tables in the Books database with the

following requirements:

Add a new publisher who is the publisher for a

new book

written by a new author. That book should be

ordered by the new customer you are adding.

Note: Be sure to use different numeric values for the various primary keys in this

database. For example: make sure the customernum is different from the

ordernum. If you use the same values for the PKs then you will lose points. The

order of the statements you use in your script is important.

$2.$ Database: books; remove all the new records you added above in this assignment.

Note: As above, the order of the statements is crucial.

$3.$ Database: lyric; Change the base pay to $$400\mathrm{.}00$ for the salesperson whose ID is $2.$

$4.$ Database: lyric; Give salesperson Clint Sanchez a $$50$ raise in base pay.

$5.$ Database: lyric; Member Mary Chrisman works from her home. Set her work phone to

the value of her home phone without entering his actual home phone number in the

SQL statement

$6.$ Database: lyric; Change the record for the title $$Word Live$$ to set the UPC to

$4238619983$ and the Genre to jazz.

$7.$ Database: lyric; Change the record so that all members who live in Canada and who

have previously been managed by the salesperson with ID $2$ will now be managed by the

salesperson with ID $3.$

$8.$ Database: lyric; Change all salespeople names to lowercase.

$9.$ Database: crashcourse $($cc$)$; Change the email address to $$no email$$ if the cust$\_$email

value is null.

$10.$ Database: crashcourse $($cc$)$; double the quantity of items ordered for all records in

orderitems.