Задача 2/13

WITH cte AS (
    SELECT
        stackoverflow.posts.creation_date::date AS date,
        COUNT(stackoverflow.posts.id) AS count
    FROM
        stackoverflow.posts
        INNER JOIN stackoverflow.post_types ON stackoverflow.post_types.id = stackoverflow.posts.post_type_id
    WHERE
        stackoverflow.post_types.type = 'Question'
        AND stackoverflow.posts.creation_date::date BETWEEN '2008-11-01' AND '2008-11-08'
    GROUP BY
        stackoverflow.posts.creation_date::date
)
SELECT
    ROUND(AVG(count), 0)
FROM
    cte