Identify Users Interested in Group Video Calls

Q: How do I practice SQL interview questions?

PracHub provides an interactive SQL console where you can write and test queries against real database schemas. Get instant feedback and compare your solution with the expected output.

Q: What difficulty level is this coding question?

This is a medium difficulty Data Manipulation (SQL/Python) question, commonly asked during Onsite rounds at Meta.

Q: What role is this question designed for?

This question is commonly asked for Data Scientist candidates at Meta during technical interviews.

Question

video_calls

caller | recipient | ds        | call_id | duration

u1     | u2        | 2023-09-01| c100    | 320

u3     | u4        | 2023-09-01| c101    | 0

u2     | u1        | 2023-09-02| c102    | 180

​

dim_all_users

u1      | 25-34      | US      | iOS       | 1        | 2023-09-01

u2      | 35-44      | IN      | Android   | 1        | 2023-09-01

u3      | 18-24      | US      | Android   | 0        | 2023-09-01

##### Scenario

Using call-level logs and user attributes, estimate user interest in group video calls.

##### Question

Write SQL to identify users who appear interested in group video calls using only the tables below.

##### Hints

Derive number of unique recipients per caller per day and filter callers exceeding a threshold.

PracHub · Accepted Answer

This question evaluates a data scientist's ability to perform SQL-based event-level data manipulation, aggregation, joins, and user-level feature derivation from call logs and user attribute tables.

Quick Overview

Identify Users Interested in Group Video Calls