Using theProduction.ProductCategoryandProduction.ProductSubcategorytables in the [AdventureWorks2012] database, please help me to make a stored proceduresp_CatSubproviding the category ID, category name, subcategory ID, and subcategory name of the products whose subcategory ID to be entered by the user. Make sure you create stored procedures in your own database. If you want to alter the procedure, you can use 'alter procedure'.

1. Show the procedure definition.
2. Execute sp_catSub with the subcategory ID equal to 10.

With explanation and output please so I can compare my answers.