Advertisement
Guest User

Untitled

a guest
Jul 7th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT receiver_id,(
  2.    SELECT json_build_object(key, SUM(value::TEXT::INT))
  3.    FROM json_each(json_object_agg(sender_id, point)) GROUP BY key
  4. ) as sended_points
  5. FROM slack_post_reactions AS spr
  6. JOIN reward_logs AS rl ON spr.id = source_id
  7. AND source_type = 'slack_post_reactions'
  8. AND DATE_TRUNC('month', rl.created_at) = DATE_TRUNC('month', CURRENT_DATE)
  9. GROUP BY receiver_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement