Streak5

List of Users Who Have Accessed Recent All 5 Days

Description

This query will return the list of Users who accessed recent all 5 days. This is used to identify the highly engaged users.

Sample Input

access
time user_id
1416435585 2
1416435586 3
1416435587 5
1416435588 1
... ...

Query


to view this query

Sample Output

user_id access_count
11 5
21 5
30 5
31 5
67 5