select is_default ,high_quantity, count(*), sum(click) , sum(click)/count(*) ,sum(pay) , sum(pay)/count(*) from ( select queryseg_norm_d,item_id,queryseg_norm,if(s_tag in ('1','3','5','7'),'Y','N') is_default ,S_th , if(label=1,1,0) click, if(label=4000,1,0) pay ,if(coalesce(S_th,0)>=10000,1,0) high_quantity from search_offline.s_c2m_offline_stacking_aop_sample_orc where ds=max_pt('search_offline.s_c2m_offline_stacking_aop_sample_orc') ) ta group by is_default ,high_quantity ;