如何按类别查找高质量用户？

[th21]

Add username to two queries

Hi, I decide to open new topic for this: Top quality users in last six months Well, for the Top quality users in last six months, I used the 2nd version from query. And I added the username; and a :limit param. -- [params] -- int :limit = 20 SELECT sum(p.score) / count(p) as "average score per post", count(p.id) as post_count, -- p.user_id, u.username FROM posts p JOIN users u ON u.id = p.user_id WHERE p.created_at >= CURRENT_DATE - INTERVAL '6 month' AND NOT u.admin …

我一直在寻找如何在特定类别中查找最有价值的用户，并发现了这个帖子。想知道如何基于类别利用类似的查询。

我尝试按类别 ID 查询帖子，但发现 posts 表中并没有提供类别 ID。