mysql - SQL SUM 仅返回值 >=1

Question

我有一个简单的查询，我只想返回值

SELECT advisor AS advisor,
SUM(`outcome` LIKE '%TPS_Approved%') AS approved
FROM shift_report 
WHERE `team`!=6 AND date>20150720 AND date<20150728
GROUP BY `advisor` 
ORDER BY `advisor`

我只希望它返回顾问和批准的计数(如果计数 >=1)

Answer 1

这能达到你想要的效果吗？

SELECT advisor AS advisor,
count(*) AS approved
FROM shift_report 
WHERE `team`!=6 AND date>20150720 AND date<20150728 and `outcome` LIKE '%TPS_Approved%'
GROUP BY `advisor` 
ORDER BY `advisor`