基本需求 找到发博量大于1000的用户并排序:group by + having select count(*) as num,uid from status group by uid having(count(*)>1000) order by count(*) desc 统计平均发博量:group by+子查询