select match_id,screen_name winner_name from battle,player where battle.winner=player.player_id;
+----------+----------------------+
| match_id | winner_name          |
+----------+----------------------+
|        1 | Red Mustang   ~PoOp~ |
|        2 | Red Mustang   ~PoOp~ |
+----------+----------------------+