Skip to main content
๐Ÿ› Bug HuntSQ SQL Mediumโšก+20 XP

Aggregate Without GROUP BY

This query fails when mixing aggregate and non-aggregate columns.

๐Ÿ› Find the bug
1SELECT name, COUNT(*)
2FROM employees;
๐Ÿ› The bug is on line 1

๐Ÿ”ง Select the correct fix: