s elect CONCAT(YEAR(mgt.occur_time),'-',DATE_FORMAT(mgt.occur_time,'%m')) months ,
sum(mgt.occur_growth_value) as occurGrowthValue
from member_growth_track mgt,credit_acct ca
WHERE mgt.credit_acct_id=ca.credit_acct_id
and ca.channel_code=#{channelCode} and ca.phone_no=#{phoneNo}
sum(mgt.occur_growth_value) as occurGrowthValue
from member_growth_track mgt,credit_acct ca
WHERE mgt.credit_acct_id=ca.credit_acct_id
and ca.channel_code=#{channelCode} and ca.phone_no=#{phoneNo}
and mgt.occur_time BETWEEN #{startTime} AND sysdate() group by months;
//occur_time为数据库中的时间字段 occur_growth_value为要统计的值