How can I count posts in last month by a specific group of users?

[Mittineague]

Is this close?

Posts created for period

Posts created for period Got what I need (thanks @meglio) so updating this for future posterity. -- [params] -- date :date_from -- date :date_to -- int :min_posts = 1 WITH user_activity AS ( SELECT p.user_id, count (p.id) as posts_count FROM posts p LEFT JOIN topics t ON t.id = p.topic_id WHERE p.created_at::date BETWEEN :date_from::date AND :date_to::date AND t.deleted_at IS NULL AND t.visible = TRUE AND t.closed = FALSE AND t.archived = FALSE…