O1 This question asks you to write the code ( SQL -Server) to do the following ( label vour 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 xxx is to be replaced with your initials.e.g,, my table would be SupplierRR 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 type with 10 maximum character, 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 3. The accompanving Tuple Data Set ABC DEF XXT ZZT 12 15 12 13 Phx 20 30 40 Tucson Phx