Based on the stored procedure concepts you have learnt during this semester, answer A, B and C: A. Write astored procedure code (the name of the stored procedure is GetAddress) that enables you toquery the Person.Address table from the Adventure Works database, but instead of getting back all records, limit it to just a particular city. B. Write the code that calls the stored procedure created in (a) C. Write the code that drops the stored procedure created in (a)