# Amending sample Gamification scoring badge

**URL:** https://meta.discourse.org/t/amending-sample-gamification-scoring-badge/275737
**Category:** Data & reporting
**Tags:** gamification, sql-triggered-badge
**Created:** [June 20, 2023, 11:35pm UTC](https://meta.discourse.org/t/amending-sample-gamification-scoring-badge/275737 "2023-06-20T23:35:03Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [October 8, 2023, 7:52pm UTC](https://meta.discourse.org/t/amending-sample-gamification-scoring-badge/275737/2 "2023-10-08T19:52:02Z")

</div>

I think you could add in something like:

```sql
SELECT user_id, CURRENT_TIMESTAMP AS granted_at 
FROM gamification_scores
WHERE date >= CURRENT_DATE - INTERVAL '1 MONTH'
  AND user_id > 0
  AND (:backfill OR user_id IN (:user_ids))
GROUP BY 1
HAVING SUM(score) > 1000

```

---

_[View the full topic](https://meta.discourse.org/t/amending-sample-gamification-scoring-badge/275737)._