Skip to main content
Journey Uncommon Logo
JourneyUncommon
easySQLGROUP BY and HAVINGSingle-choice MCQ

In most strict SQL databases (and standard SQL), why does this query fail?

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