SQL for Time-Window User Data | Dataford Interview Questions

Write a SQL query to extract Oura user data for a specific time frame.

Use the user_health_metrics table and return records from January 1, 2025 through January 3, 2025, inclusive.

Output

One row per metric record, with columns user_id, metric_date, sleep_score, and readiness_score.
Include only records within the specified date range.
Order by user_id ascending with NULL user IDs last, then metric_date ascending.

user_health_metrics

Column	Type	Description
metric_idPK	INT	Unique identifier for the metric record
user_id	VARCHAR(20)	Oura user identifier
metric_date	DATE	Date associated with the metric record
sleep_score	INT	Daily Oura sleep score
readiness_score	INT	Daily Oura readiness score

Your question is SQL for Time-Window User Data. 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.

Write a SQL query to extract Oura user data for a specific time frame.

Use the user_health_metrics table and return records from January 1, 2025 through January 3, 2025, inclusive.

One row per metric record, with columns user_id, metric_date, sleep_score, and readiness_score.
Include only records within the specified date range.
Order by user_id ascending with NULL user IDs last, then metric_date ascending.

user_health_metrics

Column	Type	Description
metric_idPK	INT	Unique identifier for the metric record
user_id	VARCHAR(20)	Oura user identifier
metric_date	DATE	Date associated with the metric record
sleep_score	INT	Daily Oura sleep score
readiness_score	INT	Daily Oura readiness score

Your question is SQL for Time-Window User Data. 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.