Steps Over 5 Consecutive Days | Dataford Interview Questions

Write a SQL query to find the average daily step count for users who have been active for at least 5 consecutive days.

Use positive step counts to define an active day. A user qualifies when they have at least one uninterrupted five-day sequence, and the average should include all positive daily step records for qualifying users.

Output

One row per qualifying user with user_id and average_daily_steps.
Round average_daily_steps to two decimal places and order by user_id ascending.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Garmin user identifier
display_name	VARCHAR(100)	Optional user display name

daily_steps

Column	Type	Description
step_idPK	INT	Unique daily step record identifier
user_id	INT	User associated with the step record
step_date	DATE	Calendar date of the step measurement
step_count	INT	Number of steps recorded for the date

Your question is Steps Over 5 Consecutive Days. 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