MySQL sum の条件の指定法

不正解
select n1, sum(come_with) as cw from entries1 group by n1 where status1 in (‘c’,’d’,’e’)

正解
select n1, sum(come_with) as cw from entries1 where status1 in (‘c’,’d’,’e’) group by n1

すっきり！！！