User Connection Score

A hard SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

hard

Seniority

L5

Problem

In the chat messages table, sender and reply-to pairs represent bidirectional connections. Each user's connection score is their total unique connections divided by total unique users on the platform, expressed as a percentage.

Summary

Every user has a social score.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.