# Is it possible to have a badge for 100 solutions?

**URL:** <https://meta.discourse.org/t/is-it-possible-to-have-a-badge-for-100-solutions/281520>\
**Category:** Data & reporting\
**Tags:** solved, sql-triggered-badge\
**Created:** [October 7, 2023, 1:36pm UTC](https://meta.discourse.org/t/is-it-possible-to-have-a-badge-for-100-solutions/281520 "2023-10-07T13:36:56Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![barto\_95](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/barto_95/32/199996_2.png) [@barto\_95](https://meta.discourse.org/u/barto_95)\
**Post date:** [October 8, 2023, 10:12am UTC](https://meta.discourse.org/t/is-it-possible-to-have-a-badge-for-100-solutions/281520/3 "2023-10-08T10:12:21Z")

</div>

> [@JammyDodger](#):
>
> Though to create one for 100, you can copy the SQL of one of those, change the threshold, and add it back in as a new custom SQL-triggered badge. There’s more info on that in [Create Triggered Custom Badge Queries](https://meta.discourse.org/t/create-triggered-custom-badge-queries/19336), and how to enable it here [Enable Badge SQL](https://meta.discourse.org/t/badge-sql-can-no-longer-be-edited-by-default/47894).

Thank’s for your reply I understand now 🙂

But when i test this query:

```sql
SELECT post_id, user_id, created_at AS granted_at
FROM (
         SELECT p.id AS post_id, p.user_id, pcf.created_at,
                ROW_NUMBER() OVER (PARTITION BY p.user_id ORDER BY pcf.created_at) AS row_number
         FROM post_custom_fields pcf
              JOIN badge_posts p ON pcf.post_id = p.id
              JOIN topics t ON p.topic_id = t.id
         WHERE pcf.name = 'is_accepted_answer'
           AND p.user_id <> t.user_id -- ignore topics solved by OP
           AND (:backfill OR p.id IN (:post_ids))
    ) x
WHERE row_number = 100

```

The result is :  
Just 2 badges for 2 users but I know a other user have mor than 100 and not show on result query…

 ![image](https://global.discourse-cdn.com/meta/original/4X/a/c/9/ac9c0edc491169c6405da0638e904908dc5ba872.png)

But this user have 106 solution:

 ![CleanShot 2023-10-08 at 12.39.28](https://global.discourse-cdn.com/meta/original/4X/2/5/8/25803cdb8989209cd6b22f95a293930305f2aa05.png)

Just another question it’s possible to change the text for my language ?I don’t understand how to that

---

_[View the full topic](https://meta.discourse.org/t/is-it-possible-to-have-a-badge-for-100-solutions/281520)._