SELECT * FROM FUNCIONARIO

SELECT 'AULA' AS 'FMU', 100*50 AS 'CALCULO', * FROM FUNCIONARIO

SELECT NM_FUNCIONARIO, SEXO, SALARIO FROM FUNCIONARIO

SELECT NM_FUNCIONARIO, SEXO, SALARIO, SALARIO + SALARIO*0.05 AS 'NOVO SALARIO' FROM FUNCIONARIO

SELECT NM_FUNCIONARIO, DATA_ADMISSAO, YEAR(DATA_ADMISSAO) AS 'ANO', MONTH(DATA_ADMISSAO) AS 'MES', DAY(DATA_ADMISSAO) 'DIA' FROM FUNCIONARIO;

SELECT SUBSTRING(CEP,1,5) AS 'CEP', + '-' + SUBSTRING(CEP,6,3) AS 'CEP COM HIFEN' FROM FUNCIONARIO