7 Day Streak
Given a table with event logs, find the percentage of users that had at least one seven-day streak of visiting the same URL.
Note: Round the results to 2 decimal places. For example, if the result is 35% return 0.35.
Example:
Input:
events table
| Column | Type |
|---|---|
user_id |
INTEGER |
created_at |
DATETIME |
url |
VARCHAR |
Output
| Column | Type |
|---|---|
output |
FLOAT |
.....
Loading editor