A number of page views. This is often used to measure the popularity of the website.
SELECT
TD_TIME_FORMAT(time,
'yyyy-MM-dd',
'JST') AS DAY,
COUNT(1) AS pv
FROM
access
GROUP BY
TD_TIME_FORMAT(time,
'yyyy-MM-dd',
'JST')
ORDER BY
DAY ASC| time | user_id |
|---|---|
| 1416435585 | 2 |
| 1416435586 | 3 |
| 1416435587 | 5 |
| 1416435588 | 1 |
| ... | ... |
| 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 |