Hi guys. Can you help me, please with a stored procedure at SQL? I will attach the diagram. Thank you very much. Here are the requirements:

Create 2 stored procedures that each use at least 1 built-in DBMS function within the stored procedure.

a) Scenario of why and when the stored procedure could be used.

b) SQL used to create the stored procedure

TRIP RESERVATION TRIP ID TRIP NAME START LOCATION STATE DISTANCE MAX GRP SIZE TYPE SEASON RESERVATION ID TRIP ID TRIP DATE NUM PERSONS TRIP PRICE OTHER FEES GUEST NUM TRIP GUIDES TRIP ID GUIDE NUM GUEST GUIDE GUIDENUM LAST NAME FIRST NAME ADDRESS CITY STATE POSTAL CODE PHONE NUM HIRE_DATE GUEST NUM LAST NAME FIRST NAME ADDRESS CITY STATE POSTAL CODE PHONE NUM