sql语句 case when or

sql语句 case when or 自己写的sqlselect date_format(createDate,'%Y-%m-%d') as createDate,count(case when reqtype='runUp' then imei end) as runUp,count(case when (reqtype='login' or reqtype='register') then imei end) as loginFROM (select distinct imei,date_format(createDate,'%Y-%m-%d') as createDate,reqtypefrom stat_user_loginreq_201312 where 1=1 and DATE_FORMAT(createDate,'%Y-%m-%d') = '2013-12-01' ) AS g group by DATE_FORMAT(createDate,'%Y-%m-%d') order by createDate 查出来的count（case when (reqtype='login' or reqtype='register') then imei end）的值和select COUNT(distinct imei),date_format(createDate,'%Y-%m-%d') from stat_user_loginreq_201312 where 1=1and (reqtype='login' or reqtype='register')and DATE_FORMAT(createDate,'%Y-%m-%d') = '2013-12-01' group by DATE_FORMAT(createDate,'%Y-%m-%d') order by createDate查出来的不一样