Chosen Payments interview question

Create a stored procedure.