sql计算总数

 select
d.store ,count(*),f.created_date,f.plan_state,g.channel_type
 from patrol_plan_result d
left JOIN patrol_plan f on d.patrol_plan=f.id
LEFT JOIN  basic_crm_channel g on  g.CHANNEL_NBR=f.store
 where d.created_date>="2015-05-01" and f.exe_start_time>="2015-05-01"
and f.exe_end_time<="2015-05-31" and  f.plan_type=1 and g.is_display=0
and g.STATUS_CD=1000 and g.CHANNEL_CLASS=10
group by d.store  having count(*) <=30