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`
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`