- -- update the existing player_elos entries that have a higher elo on the loser
- -- update xonstat.player_elos pe
- -- set elo = newpe.elo
- -- from
- -- (select lpe.game_type_cd, lpe.elo
- -- from xonstat.player_elos wpe, xonstat.player_elos lpe
- -- where wpe.game_type_cd = lpe.game_type_cd
- -- and wpe.player_id = 67
- -- and lpe.player_id = 720
- -- and lpe.elo > wpe.elo) newpe
- -- where player_id = 67
- -- and pe.game_type_cd = newpe.game_type_cd;
-