mssql_Study/select as.sql

USE Study
GO

SELECT ENAME, SALARY * 12 FROM EMPLOYEE

SELECT ENAME, SALARY * 12 AS YEARSALARY FROM EMPLOYEE