排行榜前50名（每月）

数据与报告
,
1

关于查询每月排行榜前 50 名的成员？这比选择总欢呼次数更好，因为它能推动永久性贡献。

该徽章应该能在我们的实例中启用一个特定事件 :slight_smile:

2 个赞
2

也许像这样可以解决问题？

SELECT user_id, CURRENT_TIMESTAMP AS granted_at, SUM(score) AS score
FROM gamification_scores
WHERE date >= CURRENT_DATE - INTERVAL '1 MONTH'
  AND user_id > 0
GROUP BY 1
ORDER BY score DESC
LIMIT 50
2 个赞
3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.