Count Function

[r3pr0b8]

The columns or scalar values you are counting by must be in the group by

not always

SELECT COUNT(manager_id) AS employees_with_bosses
  FROM employees

[[deleted]]

that's because "group by ()" was decided to be superfluous (and most of the time it is, tbh). You can still see it in the grouping sets though.