Query w/Group By

Who do management people always want it complex?

I need to run this query grouping by user Id and month:

SELECT userid||','||count(*)||','||sum(tranamt_n) FROM ej1
WHERE effctvdate>=to_date('01/01/2007','mm/dd/yyyy') and corrstat=' ' and tranamt_n>0
and officename='Linebarger'
group by userid, TO_CHAR(SYSDATE,'MM');

I have yet to figure this one out........ Received on Wed Feb 27 2008 - 13:38:59 CST