You have almost completed the first portion of it... I'll give you a push in the right direction... Name a column by using the AS keyword, like this:
select FirstName + ' ' + LastName as [Employee Name]
from Employees;
The next parts you need to use the len() function, instr(), mid() and Order By.
Have a crack at it.