This is the problem, Im usin SQL SERVER 2012 just started back:
Select the Employee's First Name, concatenated to the Last name,
separated by a space. Call the column 'Employee Name,' the length of this
employee name Length, the location of the first 'a' in the name 'A Location,'
and the 3–5 characters from the name 'Substring.' Order the results by the
Employee Name using the alias.