SQL Practice Logo

SQLPractice Online

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: