d4/7

A list of people who accessed more than 4 times within 7 days.

Description

A list of people who accessed more than 4 times within 7 days. This is used to list up all the engaged users. The example query below users '2012-04-15' as the ending date.

Sample Input

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

Query


to view this query

Sample Output

day access_count
3 5
1 4
2 7
4 8
10 10