Market Research Data Use Cases | Dataford Interview Questions

Explain SQL basics and how you would apply them to business use cases.

For the practical portion, write a PostgreSQL query using the supplied respondent and response data. Return market-level survey performance for completed, scored responses recorded during Q1 2025.

Output

One row per market, including markets with no qualifying responses
Columns: market, scored_response_count, average_score, and positive_rate_pct
Sort by average score descending, placing markets without scores last, then market ascending

Schema

respondents

Column	Type	Description
respondent_idPK	INT	Unique respondent identifier
market	VARCHAR(100)	Respondent market
panel_status	VARCHAR(30)	Current panel participation status

responses

Column	Type	Description
response_idPK	INT	Unique survey response identifier
respondent_id	INT	Respondent who submitted the response
response_date	DATE	Date the response was recorded
status	VARCHAR(30)	Response completion status
score	INT	Survey score from 0 through 5

Your question is Market Research Data Use Cases. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem