T
SELECT users.id, users.last_name, users.first_name, SUM(xp_awards.xp) as sum, SUM(xp_awards.xp) FILTER (WHERE xp_awards.created_at > '2019-09-20 21:37:21') as weekly_sum FROM "users" INNER JOIN "xp_awards" ON "xp_awards”.”user_id” = “users”.”id” GROUP BY users.id