7 Day Streak
Have you seen this question before?
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.
Use Shift + Enter to run query