Calculate Daily Survey Response Rates by Country

Company: Meta

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Overview: Work through a PostgreSQL survey-analysis task that compares impressions and responses by date and country. It exercises careful joins, distinct-user counting, orphan-event handling, numeric rate calculation, output grain, and deterministic ordering.

Read the full Meta Data Scientist interview experience this question came from