我通过咨询才知道的sql语句写法

1.取用户个数,并且条件是balance相加>1000的

select count(*),region from (select region, entityid,sum(balance) from am_score_balance where scorecycle='200801'ITPUB个人空间yO5C,cN
group by region,entityidITPUB个人空间^O _w4By
having
+l+@-zI m%l%g*[/nF0sum(balance)>1000)
B$B;F1y5l`!ar0group by region;