Postgresql：尝试获取过去 10 十天的平均计数

使用PostgreSQL计算过去10天的平均计数

sql
CREATE TABLE events (
    event_time TIMESTAMP,
    event_type VARCHAR(255)
);

sql
SELECT
    date_trunc('day', event_time) AS day,
    COUNT(*) AS event_count
FROM
    events
WHERE
    event_time >= current_date - interval '10 days'
GROUP BY
    day
ORDER BY
    day;

sql
SELECT
    date_trunc('day', event_time) AS day,
    COUNT(*) AS login_count
FROM
    events
WHERE
    event_time >= current_date - interval '10 days'
    AND event_type = 'login'
GROUP BY
    day
ORDER BY
    day;