This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Social Graph Engineer at LinkedIn. The connections team is building a dashboard that shows active follow relationships in a human-readable format. The raw relationships table stores only follower_id and followee_id, but the dashboard needs to display the username and full name for both participants. This requires joining the users table twice against the relationships table — once for the follower and once for the followee.
You are a Social Graph Engineer at LinkedIn. The connections team is building a dashboard that shows active follow relationships in a human-readable format. The raw relationships table stores only follower_id and followee_id, but the dashboard needs to display the username and full name for both participants. This requires joining the users table twice against the relationships table — once for the follower and once for the followee.