Tracking Ping Pong game results and stats for players

Ok we’re having some family fun playing ping pong and we want to track games. Ideally, we would be able to track game results, player stats such as wins/losses, points per game average, total points, etc. While also keeping track of game stats like who played who, what the final score was, the game date, etc.

I can’t seem to figure out how to track the game info and also have a table to that calculates player stats. The issue is having player 1 and player 2, so when I connect the Players table to the Games table, I have to connect it twice because there are two players.

Anyway, here’s the base:

Any help greatly appreciated!