Question: how to change column name in select query?
Answer: SELECT FirstName AS First , LastName AS Last FROM Person.Person; ... 
— Try rewriting our first example without using AS. ... 
SELECT UPPER(LastName) as [LAST NAME] FROM Person.Person. ... 
-- Answer SELECT DISTINCT UPPER(FirstName) AS [Distinct Names] FROM Person.Person;