Hello we are using adventure works 2014 sample database and Im confused on this question . Have a little code so far but stuck

Create a Word document that includes the SQL query code used to explore the database tables and answer the following questions.

Your manager has asked you to create a stored procedure for an application the business is developing. For the application, management has requested that when a "City" is selected, it returns with the corresponding region. By integrating code, the business will be able to return results quickly for users. Use the Address, StateProvince, and SalesTerritory tables and name the procedure "GetRegion." TIP: Use GO.

Explain why a stored procedure (SPROC) is a good way to address database security. Include specific examples to illustrate your main ideas.