Hello! I came across the codecademy community and saw that they have 3 badges based on how much time a member spent reading. Does anyone have any idea how we could create a badge like that? [image] So far I made this badge inspired by that Reader badge, but I have no idea what number is this (26 …

This query lists users who spent more than 480 hours reading posts. I hope it helps. -- millisecond conversion: [qtt hours * 3600000]: 480 * 3600000 = 1,728,000,000 WITH time_reading AS ( SELECT user_id, SUM(msecs) hours FROM post_timings GROUP BY user_id HAVING…

Your query works fine, so thanks a million times! :slightly_smiling_face:

読書時間バッジ？

コミュニティデータとレポート

cosdesign (Cos) 2021 年 2 月 5 日午前 10:00 4

クエリが正常に動作しました。本当にありがとうございます！

トピック		返信	表示
Badge based on 'read time' Data & reporting sql-triggered-badge	3	201	2015 年 3 月 18 日
Badges for reading [ :warning: intensive] Data & reporting sql-triggered-badge	5	336	2015 年 8 月 7 日
Badge granted to our staff members that have read the guidelines placed in our hidden staff category Data & reporting sql-triggered-badge	11	338	2015 年 3 月 3 日
Badge for reading a topic? Data & reporting sql-triggered-badge	6	553	2023 年 10 月 9 日
Badge for reading a page? Data & reporting sql-triggered-badge	0	284	2023 年 12 月 8 日

読書時間バッジ？

関連トピック