# Posts Read (Daily)

**URL:** https://meta.discourse.org/t/posts-read-daily/275133
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [5월 1, 2016, 4:53오전 UTC](https://meta.discourse.org/t/posts-read-daily/275133 "2016-05-01T04:53:00Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![mcwumbly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mcwumbly/32/103861_2.png) [@mcwumbly](https://meta.discourse.org/u/mcwumbly)
#### Post date: [5월 1, 2016, 4:53오전 UTC](https://meta.discourse.org/t/posts-read-daily/275133/1 "2016-05-01T04:53:00Z")

</div>

### Posts Read (Daily)

Total number of new posts read by all users per day

```sql
SELECT visited_at as day,
count(1) as users,
sum(posts_read) as posts_read,
sum(posts_read) / count(1) as avg_posts_read_per_user
FROM user_visits 
group by visited_at
order by visited_at desc

```