Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Members Active on Consecutive Days

Return members who worked out on two consecutive calendar days at least once.

Table schema

Workouts(id INT PRIMARY KEY, member VARCHAR(10), workout_date DATE, minutes INT, calories INT)

Sample data

id | member | workout_date | minutes | calories
1 | Ann | 2026-09-01 | 30 | 250
2 | Ann | 2026-09-02 | 45 | 400
3 | Ann | 2026-09-04 | 60 | 500
4 | Bob | 2026-09-01 | 20 | 150
5 | Bob | 2026-09-03 | 25 | 200
6 | Cy | 2026-09-02 | 90 | 700

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.