g create a procedure that has one input parameter a value for mgr id , and an out parameter to return the employee id with the oldest hire date for that manager (so the most senior employee that reports to that manager). you will have to do a little research on the output parameter and how to use it.