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

ORDER LINE ORDERS ORDERNUM ITEM-NUM NUMLORDERED QUOTED PRICE ORDERNUM ORDER DATE CUSTOMER NUM CUSTOMER CUSTOMER NUM CUSTOMER NAME STREET CITY STATE POSTAL CODE BALANCE CREDIT LIMIT REP NUM ITEM ITEM-NUM REP REP NUM ON HAND CATEGORY STOREHOUSE PRICE LAST NAME FIRST NAME STREET CITY STATE POSTALCODE RATE