Access Recency

The distribution of access recency.

Description

By looking at the last access day of each user, you can see the distribution of the recency of the access.

Sample Input

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

Query


to view this query

Sample Output

term_day cnt
0 621
1 121
2 71
3 61
4 41
5 31
6 11
7 3
8 1