既に付与されたバッジの数に基づく追加バッジ？

[cosdesign (Cos)]

Hi. I was wondering if we could create a special badge for users already being granted with 30+ badges ( excluding system and discobot ).
So far this is the closest query I’ve found but is not for this use.

[cosdesign (Cos)]

ついに成功しました。(私の最初のバッジです ) ご興味のある方はこちらです

SELECT user_id, current_timestamp granted_at 
FROM user_badges  
GROUP BY user_id 
HAVING count(*) >= 30