# 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:** 6

<div class="post-metadata">

**Author:** ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)\
**Post date:** [September 3, 2023, 11:35am UTC](https://meta.discourse.org/t/query-to-create-some-groups-based-on-activity/277156/6 "2023-09-03T11:35:21Z")

</div>

> [@alefattorini](#):
>
> - likes received (30 - 100 - 200 )
> - posts read 1k 2k 5k
> - minimum of post over last year

These look suspiciously like existing Trust Level groups (and the population of those is automated by similar measures) - why don’t you just amend the existing thresholds and have it all done for you?

`/admin/site_settings/category/trust`

e.g. for TL2 (members are in `trust_level_2` or equivalent in your dialect):

 ![image](https://global.discourse-cdn.com/meta/original/4X/e/3/7/e3731526a584ee303b2bf73e7cbc2e8b5d823a45.png)

---

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