Your question is Extracting User Health Metrics. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
user_id = 1002 where metric_type is weight or fasting_glucose.| 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 |