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

Compute accepted friend count per user and rank by network size, handling bidirectional friendships with UNION ALL.

Relevant Tables

usersfriendships

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics: