Master-level task from Meta/LinkedIn. **Condition:** Analyze the social graph of users and find "influential" users. **Tables:** follows, users, posts, likes, comments **Requirements:** 1. For each user, calculate: - direct_followers (direct followers) - reach_2_levels (followers + followers of followers, unique) - mutual_connections (number of mutual follows) - engagement_rate (likes + comments on posts / number of followers) - influence
Sign in to solve
Start Solving