A. Issue the command "Select * from Categories;" B. 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. After this command - do the Select from 5A, C. 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. After this command - do the Select from 5A. D. 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. After this command - do the Select from 5A. E. Write an INSERT statement that adds this row to the Products table: ProductID: The next automatically generated ID CategorylD: 4 ProductCode: DGX_640 ProductName: Yamaha DGX 640 88-Key Digital Piano Description: Long description to come. ListPrice: 799.99 DiscountPercent: 0 (this is the default) DateAdded: Today's date/time. Use a column list for this statement. After this command - do the Select from 5A. F. Write an UPDATE statement that modifies the product you added in Task 5E. This statement should change the DiscountPercent column from 0\% to 35%. After this command - do the Select from 5A. 5. Create the following SQL queries using the specified DML statements in the query window. Comment each step in the script. A. Issue the commands Select count() from Products; Select count () from Categories; B. 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. After this command - do the Selects from 5A. C. Issue the command "Select count(*) from Customers;" D. Write an INSERT statement that adds this row to the Customers table: EmailAddress: rick@raven.com Password: (empty string) FirstName: Rick LastName: Raven Use a column list for this statement. After this command - do the Select from 5C. E. 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. After this command - do the Select * from Customers where emailAddresss = 'rick@raven.com'; F. Write an UPDATE statement that modifies the Customers table. Change the password column to "reset" for every customer in the table. After this command - do the Select * from Customers. G. Run your created script