Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DEPARTMENT_ID
- ,(SELECT * FROM HR.DEPARTMENTS) AS 'Nome do Departamento'
- ,MIN(SALARY) AS 'salario minimo'
- ,MAX(SALARY) AS 'salario maximo'
- ,CAST(AVG(SALARY) AS NUMERIC(8,2)) AS 'salario medio'
- FROM [HR].[EMPLOYEES]
- GROUP BY DEPARTMENT_ID
Add Comment
Please, Sign In to add comment