Try it Yourself: SQL Group By – Hyring Learn

LessonBack to lesson

SQL Group By

Language: SQL

SELECT department, COUNT(*) AS employee_count
FROM employees
GROUP BY department;

SELECT department, COUNT(*) AS employee_count
FROM employees
GROUP BY department;

Output

Click Run to execute this code.