select
rule_no ,
rule_name,
COUNT(1) as RuleFireTimes ,
sum(if( choose_result_type=0 ,1,0))as RuleHitTimes
from rule_record where creat_time > '2017-02-15 03:19:32' and creat_time < '2018-03-20 03:19:32' GROUP BY rule_no;
select
rule_no ,
rule_name,
COUNT(1) as RuleFireTimes ,
sum(if( choose_result_type=0 ,1,0))as RuleHitTimes
from rule_record where creat_time > '2017-02-15 03:19:32' and creat_time < '2018-03-20 03:19:32' GROUP BY rule_no;