Scenario 3-4: Manipulating Data Using INSERT and UPDATE Statements As the AdventureWorks DBA, you need to insert data into the Credit table in the Sales database using a variety of data statements, along with updating and deleting data from the same Credit table. 1. After opening SSMS, what commands would you type and execute in the AdventureWorks database to review the columns in the Sales table? 2. In the existing query window, what commands would you use that will add the following row to the Credit table? Patrick, Roberts, 6000, Roberts@telecome.usa 3. In the existing query window, what commands would you type, highlight, and execute to add the following rows to the Credit table for firstname, lastname, and credit limit? Alex, Hall, 5000 Annie, Smith, 10000 4. In the existing query window, what commands would you use to update the email address (Email) for Annie Smith in the Credit table using the Update statement?