selectcreate_time,count(distinct id) as cntfrom(selectdate_format(t1.full_time, 'yyyy_MM') as create_time,distinct t1.id as idFROM loan t1LEFT JOIN repay_record t2ON t1.id=t2.loan_idleft join sda01_user t3on t1.user_id=t3.idWHERE t1.full_time IS NOT NULL AND t1.status NOT IN(7,9) and date_format(t1.full_time,'yyyy-MM-dd')>='2014-05-06') tgroup by create_time order by create_time;以上这段sql查询时候报错,一时没看出来,哪位帮忙看一下