如何簡化這個游戲統(tǒng)計查詢？這段代碼如預期的那樣工作，但我覺得它很長，而且令人毛骨悚然。select p.name, p.played, w.won, l.lost from(select users.name, count(games.name) as playedfrom usersinner join games on games.player_1_id = users.idwhere games.winner_id > 0group by users.nameunionselect users.name, count(games.name) as playedfrom usersinner join games on games.player_2_id = users.idwhere games.winner_id > 0group by users.name) as pinner join(select users.name, count(games.name) as wonfrom usersinner join games on games.player_1_id = users.idwhere games.winner_id = users.idgroup by users.nameunionselect users.name, count(games.name) as wonfrom usersinner join games on games.player_2_id = users.idwhere games.winner_id = users.idgroup by users.name) as w on p.name = w.nameinner join(select users.name, count(games.name) as lostfrom usersinner join games on games.player_1_id = users.idwhere games.winner_id != users.idgroup by users.nameunionselect users.name, count(games.name) as lostfrom usersinner join games on games.player_2_id = users.idwhere games.winner_id != users.idgroup by users.name) as l on l.name = p.name如您所見，它由三個用于檢索的重復部分組成：玩家名稱和他們玩的游戲數量玩家的名字和他們贏得的游戲數量玩家名稱和他們輸掉的游戲數量每一部分還包括兩個部分：玩家名稱和作為Player_1參加的游戲數量玩家名稱和作為Player_2參與的游戲數量如何簡化？結果如下：           name            | played | won | lost ---------------------------+--------+-----+------ player_a                  |      5 |   2 |    3 player_b                  |      3 |   2 |    1 player_c                  |      2 |   1 |    1