We have the table below Customers. You need to create a couple of stored procedures. pid...

Transcribed Image Text:

We have the table below Customers. You need to create a couple of stored procedures. pid pname ptlf pemail 1 Mark 2 *** Maria 90000001 90000002 11 mark@email. 22 com page maria@email. 23 com H *** a. Create a stored procedure that retrieves the customers that are older than the input variable age.(2) b. Write the query to run the stored procedure, and retrieve all the customers than are older then 18.(2) c. Create a table named Customers Test which has the same schema as the Customers table (1) the d. developers that use the table Customers, need a test table that is larger than the current table, to performance. You need to create a stored procedure that creates n number of dummy customers that will be put into the table Customers Test. (5) Activate Win Go to Settings to We have the table below Customers. You need to create a couple of stored procedures. pid pname ptlf pemail 1 Mark 2 *** Maria 90000001 90000002 11 mark@email. 22 com page maria@email. 23 com H *** a. Create a stored procedure that retrieves the customers that are older than the input variable age.(2) b. Write the query to run the stored procedure, and retrieve all the customers than are older then 18.(2) c. Create a table named Customers Test which has the same schema as the Customers table (1) the d. developers that use the table Customers, need a test table that is larger than the current table, to performance. You need to create a stored procedure that creates n number of dummy customers that will be put into the table Customers Test. (5) Activate Win Go to Settings to