I have written a database with game stats, featuring winner, loser, and money won. I'm now trying to make stats for it.

[See database here](https://i.stack.imgur.com/Tyzhl.png)

I'm trying to make stats for these games, etc number of wins/losses for player, and money lost and money won.

Till now I have found three queries to achieve this.

```
SELECT COUNT(winner) AS wins, COUNT(loser) AS losses 
FROM coinflipper_games 
WHERE winner = "dba92393-5bbd-365f-8fe7-55be2707caf3" 
   OR loser = "dba92393-5bbd-365f-8fe7-55be2707caf3"

SELECT SUM(money) 
FROM coinflipper_games 
WHERE winner = "dba92393-5bbd-365f-8fe7-55be2707caf3"

SELECT SUM(money) 
FROM coinflipper_games 
WHERE loser = "dba92393-5bbd-365f-8fe7-55be2707caf3"

```

The problem is, it's in no way effective using three queries, so I'm trying to reduce this to one. Does anyone have any idea what I can do?