Consulta con el count()

[GigaZiko]

SELECT department,nombre,email, COUNT(*) Number of employees
FROM employees
WHERE salary > 25000
GROUP BY department;

asi quedaria... cualquier error me pueden corregir =P
si quieres ordenar los datos por department debes colocar el order by , osea quedari asi


SELECT department,nombre,email, COUNT(*) Number of employees
FROM employees
WHERE salary > 25000
ORDER BY department;