How to find top quality users by category?

[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 …

Was looking for how to find most valuable user in a specific category and find this, wonder how to utilize a simliar query based on category.

I was trying to query on post by category id but find the category id is not presented on posts table.