특정 주제를 해결(Solved)로 표시한 사용자를 조회하려면:
-- [params]
-- topic_id :topic_id
SELECT
target_topic_id,
acting_user_id,
created_at::date
FROM user_actions
WHERE target_topic_id = :topic_id
AND action_type = 15
ORDER BY created_at DESC
특정 주제를 해결(Solved)로 표시한 사용자를 조회하려면:
-- [params]
-- topic_id :topic_id
SELECT
target_topic_id,
acting_user_id,
created_at::date
FROM user_actions
WHERE target_topic_id = :topic_id
AND action_type = 15
ORDER BY created_at DESC