我有一个sql查询,它生成以下表格,但我希望能够获得按类别分组的标记列的总数:
代码如下:
select pic.Name as Category,
pis.Code as Code,
pis.Name as Issue,
count(it.ID) as 'total count',
sum(mc.ots) as 'Imps',
sum(case when ito.rating <50 then 1 else 0 end) as 'unfav count',
sum(case when ito.Rating =50 then 1