Calculate and Compare Survey Response Rates for User Tenure

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

Surveys

+--------+------------+--------------+----------+
| userid | date       | survey_event | response |
+--------+------------+--------------+----------+
| 101    | 2023-01-10 | notif_popup  | 5        |
| 102    | 2023-01-11 | notif_popup  | 3        |
| 101    | 2023-01-12 | notif_modal  | 4        |
+--------+------------+--------------+----------+

​

Users

+--------+------------+----------+
| userid | reg_date   | country  |
+--------+------------+----------+
| 101    | 2022-12-20 | US       |
| 102    | 2023-01-05 | CA       |
| 103    | 2023-01-07 | US       |
+--------+------------+----------+

##### Scenario

Mobile app sends a post-notification survey to users; two tables (Surveys, Users) track responses and registration dates.

##### Question

Write SQL to compute the overall response rate to the survey. 2. Using SQL, determine whether newer users rate notifications higher than long-tenured users.

##### Hints

Join, aggregate, bucket users by tenure, compare average/median response.

PracHub · Accepted Answer

This question evaluates proficiency in relational data manipulation and metric computation, including SQL joins, aggregation and cohort-based comparisons relevant to survey response analysis, and is categorized under Data Manipulation (SQL/Python) for a Data Scientist role.

Quick Overview

Quick Overview