HELP WILL ALL PLEASE $1.$Write an INSERT statement that adds this row to the Categories table: CategoryName: Brass

Code the INSERT statement so SQL Server automatically generates the value for the CategoryID column.

$2.$Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the CategoryName column to $$Woodwinds$,$ and it should use the CategoryID column to identify the row.

$3.$Write a DELETE statement that deletes the row you added to the Categories table in exercise $1.$ This statement should use the CategoryID column to identify the row.

$4.$Write an INSERT statement that adds this row to the Products table:

ProductID: CategoryID: ProductCode: ProductName: Description: ListPrice: DiscountPercent: DateAdded:

The next automatically generated ID

$4$

dgx$\_640$

Yamaha DGX $64088-$Key Digital Piano Long description to come.

$799\mathrm{.}99$

$0($this is the default$)$ Today$$s date$/$time$.$

Use a column list for this statement.

$5.$Write an UPDATE statement that modifies the product you added in exercise $4.$ This statement should change the DiscountPercent column from $0\%$ to $35\%.$

$6.$Write a DELETE statement that deletes the row in the Categories table that has an ID of $4.$ When you execute this statement, it will produce an error since the category has related rows in the Products table. To fix that, precede the DELETE statement with another DELETE statement that deletes all products in this category.

$7.$Write an INSERT statement that adds this row to the Customers table:

EmailAddress: Password: FirstName: LastName:

rick@raven.com $($empty string$)$ Rick

Raven

Use a column list for this statement.

$8.$ Write an UPDATE statement that modifies the Customers table. Change the password column to $$secret$$ for the customer with an email address of rick@raven.com.

$11$ Murach$$s SQL Server $2019$ for Developers: My Guitar Shop exercises

$9.$Write an UPDATE statement that modifies the Customers table. Change the

password column to $$reset$$ for every customer in the table.

$10.$Open the script named CreateMyGuitarShop.sql that$$s in the MGS Exercise Starts directory. Then, run this script. That should restore the data that$$s in the database. If an error message is displayed indicating that the database is in use, you$$ll need to close and restart the Management Studio and then run the script again.