- select p.player_id, p.nick, pe.game_type_cd, pe.elo, rank()
- over (partition by pe.game_type_cd order by pe.elo desc)
+ select p.player_id, p.nick, pe.game_type_cd, pe.elo, row_number()
+ over (partition by pe.game_type_cd order by pe.elo desc, pe.create_dt)