# Page View Example Queries

A number of page views. This is often used to measure the popularity of the website.

![](/assets/pv.8371fb18e409b7db8d91c9f7ba5206de8b998c26105700add7bb578293f3c674.89112c51.png)

* [Page View Query Syntax Example for Hive and Presto](/products/customer-data-platform/data-workbench/queries/page-view-example#page-view-query-syntax-example-for-hive-and-presto)
* [Sample Input](/products/customer-data-platform/data-workbench/queries/page-view-example#sample-input)
* [Sample Output](/products/customer-data-platform/data-workbench/queries/page-view-example#sample-output)


## Page View Query Syntax Example for Hive and Presto


```sql
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
```

## Sample Input

| **time** | **user_id** |
|  --- | --- |
| 1416435585 | 2 |
| 1416435586 | 3 |
| 1416435587 | 5 |
| 1416435588 | 1 |
| ... | ... |


## 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 |