匹配SQL中group by语句中给定的id集合

Question

我有一个简单的表，用于跟踪用户是否提交了特定的活动。

<表类> user_id activity_id tbody><<tr>11111222133314442111222231113222333357775111

SELECT user_id,
CASE WHEN COUNT(DISTINCT activity_id) >= 3 THEN true ELSE false END AS submitted_minimum_activities
FROM your_table_name
WHERE activity_id IN (111, 222, 333) -- replace with your list of activity_ids
GROUP BY user_id

• 筛选表，只包括activity_id在给定列表中的行
• group by user_id
• CASE检查不同的activity_ids的计数是否至少为3(这是给定列表的长度)(如果是-我们返回true -否则我们返回false)