# Query to create some groups based on activity

**URL:** https://meta.discourse.org/t/query-to-create-some-groups-based-on-activity/277156
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [August 30, 2023, 9:50am UTC](https://meta.discourse.org/t/query-to-create-some-groups-based-on-activity/277156 "2023-08-30T09:50:27Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [September 1, 2023, 12:39pm UTC](https://meta.discourse.org/t/query-to-create-some-groups-based-on-activity/277156/4 "2023-09-01T12:39:23Z")

</div>

This is great!  
How can find if the post at least 10 times over the last year?  
Not just one like in your query

How can integrate this query? [Posts created for period](https://meta.discourse.org/t/posts-created-for-period/275138)

---

_[View the full topic](https://meta.discourse.org/t/query-to-create-some-groups-based-on-activity/277156)._