diff options
Diffstat (limited to 'storage/views/Cards/Best.gosql')
| -rw-r--r-- | storage/views/Cards/Best.gosql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/storage/views/Cards/Best.gosql b/storage/views/Cards/Best.gosql new file mode 100644 index 0000000..73e3b31 --- /dev/null +++ b/storage/views/Cards/Best.gosql @@ -0,0 +1,10 @@ +SELECT + Card, + ActIndex + 1 AS Act, + Sum(Win) as Wins, + Count(*) - Sum(Win) as Losses, + ROUND(Wins / Count(*), 2) as Winrate, +FROM + CardChoice +WHERE + Picked = TRUE
\ No newline at end of file |