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 in my case is the maximum number that will show me I’m eligible for the badge). SELECT user_id, count(*) c, CURRENT_DATE as granted_at FROM post_timings GROUP BY user_id HAVING count(*) >= 26 These are my stats ( the total reading time I’m interested to pull ) [image]

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 SUM(msecs) >= 1728000000) SELECT user_id, CURRENT_TIMESTAMP granted_at FROM time_reading

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

תג על זמן קריאה?

קהילה נתונים ודיווח

cosdesign (Cos) 5 בפברואר,‏ 2021,‏ 10:00am 4

Your query works fine, so thanks a million times!

נושא		תגובות	צפיות
Badge based on 'read time' Data & reporting sql-triggered-badge	3	231	18 במרץ,‏ 2015
Badges for reading [ :warning: intensive] Data & reporting sql-triggered-badge	5	371	7 באוגוסט,‏ 2015
Badge granted to our staff members that have read the guidelines placed in our hidden staff category Data & reporting sql-triggered-badge	11	368	3 במרץ,‏ 2015
Badge for reading a topic? Data & reporting sql-triggered-badge	6	570	9 באוקטובר,‏ 2023
Badge for reading a page? Data & reporting sql-triggered-badge	0	290	8 בדצמבר,‏ 2023

תג על זמן קריאה?

נושאים קשורים