Page View

aka. PV

Description

Number of page views. This is often used to measure the popularity of the web site.

Sample Input

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

Query


to view this query

Sample Output

day cnt
2014-10-01 621
2014-10-02 121
2014-10-03 71
2014-10-04 61
2014-10-05 41
2014-10-06 31
2014-10-07 11
2014-10-08 3
2014-10-09 1