diff options
| author | ewy <ewy0@protonmail.com> | 2026-05-22 20:06:56 +0200 |
|---|---|---|
| committer | ewy <ewy0@protonmail.com> | 2026-05-22 20:06:56 +0200 |
| commit | 094846c15f4148c166ac297e26a1248bab0ab5c7 (patch) | |
| tree | d9f671bb0d34b5be52db62636278f5d3e5657283 /storage/views/Cards/Best.gosql | |
| parent | 3ea1ed1362984619b182c0ddf9a6b1dc7ba5bcd0 (diff) | |
add views, expand api, add windows opening thing overridemain
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 |