1 -- win ratio per player, per game type
5 FROM (SELECT g.game_id,
8 WHEN g.winner = pgs.team THEN 1
9 WHEN pgs.rank = 1 THEN 1
13 WHEN g.winner = pgs.team THEN 0
14 WHEN pgs.rank = 1 THEN 0
19 WHERE g.game_id = pgs.game_id
20 AND pgs.player_id = 6) win_loss
21 GROUP BY game_type_cd;