Quick 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.

Calculate Daily Survey Response Rates by Country

Company: Meta

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Quick Answer: 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.

Loading…