sql查询sum统计加条件

sql查询sum统计加条件

SELECT `project_id`,sum(CASE WHEN channel  != '头条' AND channel !='美团' THEN dialog ELSE 0 END) as dialog FROM `yy_biao` WHERE ( `start_time` >= '2020-10-01 00:00:00' AND `end_time` <= '2020-10-18 23:59:59' ) GROUP BY `project_id`