Access Frequency

The distribution of access frequency per user.

Description

The distribution of access frequency. This is useful to see the distribution of user engagement.

Sample Input

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

Query


to view this query

Sample Output

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