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

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

All non-aggregate columns must be in GROUP BY clause.

Every non-aggregate column in SELECT must be in GROUP BY

High

Column "job_title" must appear in GROUP BY