• + 0 comments

    Because we are performing the aggregate function COUNT().

    If we in TSql perform any aggregates, we need to group anything that is not calculated, into the group by clause.