Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT receiver_id,(
- SELECT json_build_object(key, SUM(value::TEXT::INT))
- FROM json_each(json_object_agg(sender_id, point)) GROUP BY key
- ) as sended_points
- FROM slack_post_reactions AS spr
- JOIN reward_logs AS rl ON spr.id = source_id
- AND source_type = 'slack_post_reactions'
- AND DATE_TRUNC('month', rl.created_at) = DATE_TRUNC('month', CURRENT_DATE)
- GROUP BY receiver_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement