select rq,count(case when zdf>=9.7 then 1 end) ,count(case when zdf<=-9.7 then -1 end)from dhq where rq>2015-05-01group by rq@唐史主任司马迁 @今日头条 (Ps.感谢 @阿葱 同学协助做Excel图)