Company SQL Question
Friendship Network Analysis
Practice this Meta style SQL interview question with live execution and instant feedback.
Problem Statement
Create a friendship network analysis showing each user with their friend count and mutual friends. Calculate mutual friends between users. Show username, total friends, mutual friend count with their best friend, and network rank.
Relevant Tables
usersfriendships
SQL Concepts Used in This Question
Strengthen your understanding with these targeted learning topics: