User stats

WITH t AS
  (SELECT
      user_id,
      (COALESCE(sum(cash_out - bet), 0::numeric)
        + COALESCE(sum(bonus), 0::numeric))::bigint AS gross_profit,
      (COALESCE(sum(cash_out), 0::numeric)
        + COALESCE(sum(bonus), 0::numeric)
        - COALESCE(sum(bet), 0::numeric))::bigint AS net_profit,
      COUNT(*) AS games_played
    FROM plays
    GROUP BY user_id)
  UPDATE users
    SET gross_profit = t.gross_profit,
        net_profit   = t.net_profit,
        games_played = t.games_played
    WHERE id = t.user_id;