Q1 --15 Points This question asks you to write the code ( SQL Server) to do the following (label your answers using these numbers): 1. Create a database using your name 2. Create a single table using the parameters below 3. Insert the given data 4a. Show a result of retrieving the ids and names from the table 4b. Show a single result summary query that retrieves the count of the number of rows and label this as "RowCount and the maximum of the status, and label that column 'MaxStatus'. 4c. Produce a single result that returns id, name, and all locations that start with P. The details for questions Q1 (use the above numbers to label your answers) Write the SQL Server code to create a database and use that in subsequent questions. Write the code to create a table named Supplierxx where xx is to be replaced with your initials. e..., my table would be SupplierPK Column parameters: id of type integer, no nulls allowed, primary key name is to be with 10 maximum characters, no nulls allowed status is to be of type integer, not null, and with a default of zero location is to be of the type with 10 maximum characters, no nulls There is a constraint on the location column that the city must be one of two {Phx, Tucson) Note: be careful of SQL reserved words