Friend Suggestions
Suggest accounts for user 1: accounts followed by people user 1 follows, excluding user 1 and anyone user 1 already follows. Return the suggested user and the number of followed people who follow them, ordered by that count descending then id.
Table schema
Follows(follower INT, followee INT)Sample data
follower | followee
1 | 2
1 | 3
2 | 4
3 | 4
3 | 5
2 | 1
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.