Untitled

WITH ass as (SELECT CAST(DATE_TRUNC('day', p.creation_date) as date) as mth, count(p.id) as cnt
FROM stackoverflow.posts as p
JOIN stackoverflow.post_types as pt on pt.id=p.post_type_id
WHERE pt.type = 'Question' and CAST(DATE_TRUNC('month', p.creation_date) as date) between '2008.11.01' and '2008.11.18'
GROUP by 1)

SELECT round(avg(cnt))
FROM ass