Next-Day Workout Retention

Problem

A fitness app records each workout session a member logs.

Table: workout_log
+-------------+------+
| Column Name | Type |
+-------------+------+
| member_id | int |
| device_id | int |
| log_date | date |
| minutes | int |
+-------------+------+
There may be several rows per member. Each row records one day on which the member logged a workout. A member's signup date is taken to be the earliest log_date they have.

Write a solution to report, for each signup date, how many members signed up on that date and the fraction of those members who logged another workout on the very next day (the day immediately after signup), rounded to 2 decimal places. Return columns signup_date, signups, and next_day_rate in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns signup_date, signups, next_day_rate.

Starter code (SQL)

SELECT *
FROM workout_log;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard