Create a procedure to allow an employee in the shipping department to update an order status to add shipping information . The BB_BASKETSTATUS table lists events for each order so that a shopper can...

1. Create a procedure to allow an employee in the shipping department to update an order status to add
   shipping information. The BB_BASKETSTATUS table lists events for each order so that a shopper can see the
   current status,
   date, and
   comments as each stage
   of the order process are finished.

Use an anonymous block to test your procedure.