阅读时间徽章？

社区 数据与报告
3

此查询列出了阅读帖子超过 480 小时的用户。希望这能帮到您。

-- 毫秒转换：[小时数 * 3600000]：480 * 3600000 = 1,728,000,000

WITH time_reading AS (
    SELECT 
        user_id, 
        SUM(msecs) AS hours 
    FROM post_timings 
    GROUP BY user_id
    HAVING SUM(msecs) >= 1728000000)

SELECT user_id, CURRENT_TIMESTAMP AS granted_at
FROM time_reading