SQL Problem

[mkinzler]

SQL-Code:

SELECT
    C_NO,
    sum(iif ( TODO_TYPE = 'Member_Dinner', 1, 0)) as MD,
    ...
from 
    CAMPS_D_TODO
group by
   C_NO, B_YEAR;