614.二级关注者

 

 

 

 

#这里要去重
select a.follower,count(distinct(b.follower)) num
from follow a
inner join follow b
on a.follower=b.followee
group by a.follower;