实现按月消费统计的SQL语句

USE EcardSystem select a.月份,消费金额=sum(a.消费金额),早餐金额=sum(a.早餐金额),中餐金额=sum(a.中餐金额),晚餐金额=sum(a.晚餐金额) from ( SELECT 月份=month(jndate), 消费金额=(-sum(jnsum)/100), 早餐金额=CASE when meals='1' then (-sum(jnsum)/100) end, 中餐金额=CASE when meals='2' then (-sum(jnsum)/100) end, 晚餐金额=CASE when meals='3' then (-sum(jnsum)/100) end FROM histrjn where (account='*****'and year(jndate)=2009) group by meals,month(jndate) )as a group by a.月份