Hello everyone I need help with this sql stored procedure question. Im confused on the whole entire stored procedure so I have no ideas how to this. Thanks in advance for the help.

Create a stored procedure called spUpdateProductPrice 1. Create 2 tables: Product and Customers 2. Using the stored procedure created, allow the user to a. Enter their Firstname, LastName, ProductName, Price, Quantity 3. Create a new record in the Products table with the information submitted by the user a. Add the current date when creating the record 4. Create a new record in the Customers table with the information submitted by the user b. Make the customer's first and last names UPPER case when creating the record