Using the My Guitar Shop database you installed in Module $1,$ develop the following queries.

To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement.

$1.$ Write an INSERT statement that adds this row to the Categories table:

category$\_$name: Brass

Code the INSERT statement so MySQL automatically generates the category$\_$id column. Execute the query and take a screenshot of the query and the results.

$2.$ Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the category$\_$name column to $$Woodwinds$,$ and it should use the category$\_$id column to identify the row. Execute the query and take a screenshot of the query and the results.

$3.$ Write a DELETE statement that deletes the row you added to the Categories table in exercise $1.$ This statement should use the category$\_$id column to identify the row. Execute the query and take a screenshot of the query and the results.

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

product$\_$id:

category$\_$id:

product$\_$code:

product$\_$name:

description:

list$\_$price:

discount$\_$percent:

date$\_$added:

The next automatically generated ID

$4$

dgx$\_640$

Yamaha DGX $64088-$Key Digital Piano

Long description to come.

$799\mathrm{.}99$

$0$

Today$$s date$/$time$.$

Use a column list for this statement. Execute the query and take a screenshot of the query and the results