请求：自定义徽章 SQL 用于总点赞数

社区 数据与报告
2

你好，欢迎你 @rapphann :slight_smile:

恐怕我也不是 SQL 大师 :slight_smile: 但我认为它会是这样的：

SELECT us.user_id, current_timestamp AS granted_at
FROM user_stats AS us
WHERE us.likes_received >= 100
AND us.likes_given >= 100
AND (:backfill OR us.user_id IN (:user_ids))