alternate

Question Select name, count(secondary) from (select f1.followed_id as profile, f2.follower_id as secondary from following as f1 join following as f2