从“游戏”列表中获取不同的行

I'm trying to show a list of games by date organized so that I have one entry for each game. The table consists of two entries for each game, the example data illustrates the layout. I can get the Home vs Away filtered easily by just filtering on the 'A' in Location. My problem is only getting one of the teams when the location is 'N' for neutral site. The creation SQL and version info is below. I'm trying to show a list of games by date orga