Exercise scoring

This exercise is worth a total of 20 points. You will receive 20 points for accurately creating the Transact-SQL statement that creates a stored procedure, as described in the instructions.

Instructions

Construct a stored procedure, named usp_GetLastName, that accepts one input parameter named EmployeeID and returns (using a SELECT Transact-SQL statement) the last name of the employee.

This question is taken from here https://www.sqlconfiguration.com/enterprise-issues-business-rules/module5/creating-stored-procedures-exercise.php