计算组内的每个条件

您可以用来

count

[GroupId]

sum

select [GroupId]     , count([GroupId]) as [TotalRows]     , sum([IsGreen]) as [TotalGreen]     , sum([IsRound]) as [TotalRound]     , sum([IsLoud]) as [TotalLoud]from [TestData]group by [GroupId]