问选择查询Oracle 11g

EN

SELECT Game_Date,
   Player.First_Name || ' ' || Player.Last_Name AS "PLAYER NAME",
   UPPER(Team1.Team_Name) AS "HOME TEAM",
   UPPER(Team2.Team_Name) AS "VISITING TEAM",
   Team1.Team_City ||' '|| Team1.Team_Name as "TEAM",
   Birth_Place1.Country
FROM Game
     JOIN Team Team1 ON Game.Team_Home_ID = Team1.Team_ID
     JOIN Team Team2 ON Game.Team_Visitor_ID = Team2.Team_ID
     JOIN Player Player1 ON Player1.Team_ID = Team1.Team_ID
     JOIN Player Player2 ON Player2.Team_ID = Team2.Team_ID
     JOIN Birth_Place Birth_Place1 ON Birth_Place1.Birth_Place_ID = Player1.Birth_Place_ID
     JOIN Birth_Place Birth_Place2 ON Birth_Place2.Birth_Place_ID = Player2.Birth_Place_ID
WHERE Birth_Place1.Country = Birth_Place2.Country
     AND Season = '2015-2016'
     AND Game_Date = '10-10-2015'
     AND Birth_Place1.Country NOT IN ('CAN', 'USA')
ORDER BY Birth_Place1.Country;