README.md

614. 二级关注者

English Version

题目描述

None

解法

SQL

SELECT followee AS follower,
        count(distinct(follower)) AS num
FROM follow
WHERE followee IN
    (SELECT follower
    FROM follow)
GROUP BY  followee
ORDER BY  followee