Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
13. Popularity Percentage
On this page

Problem

Table: Friends

+-------------+------+
| Column Name | Type |
+-------------+------+
| user1       | int  |
| user2       | int  |
+-------------+------+
(user1, user2) is the primary key (combination of unique values) of this table.
Each row contains information about friendship where user1 and user2 are friends.

Problem Definition

Write a solution to find the popularity percentage for each user on Meta/Facebook

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page