Extracting User Health Metrics | Dataford Interview Questions

Omada Health needs a focused extract of member measurements for care-team review. Write a PostgreSQL query against the health_metrics table to retrieve one member's weight and fasting glucose readings recorded during January 2026.

Requirements

Return only rows for user_id = 1002 where metric_type is weight or fasting_glucose.
Include measurements from January 1 through January 31, 2026, ordered by date and metric type.

Schema

health_metrics

Column	Type	Description
metric_idPK	INTEGER	Unique measurement identifier
user_id	INTEGER	Omada member identifier
metric_date	DATE	Date the measurement was recorded
metric_type	VARCHAR(30)	Health metric name
metric_value	NUMERIC(8,2)	Recorded numeric value
unit	VARCHAR(20)	Measurement unit

Your question is Extracting User Health Metrics. Start with the requirements and the one table 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

Requirements

Return only rows for user_id = 1002 where metric_type is weight or fasting_glucose.
Include measurements from January 1 through January 31, 2026, ordered by date and metric type.

Schema

health_metrics

Column	Type	Description
metric_idPK	INTEGER	Unique measurement identifier
user_id	INTEGER	Omada member identifier
metric_date	DATE	Date the measurement was recorded
metric_type	VARCHAR(30)	Health metric name
metric_value	NUMERIC(8,2)	Recorded numeric value
unit	VARCHAR(20)	Measurement unit

Your question is Extracting User Health Metrics. Start with the requirements and the one table 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.