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/Ancients/BestSkips.gosql | |
| parent | 3ea1ed1362984619b182c0ddf9a6b1dc7ba5bcd0 (diff) | |
add views, expand api, add windows opening thing overridemain
Diffstat (limited to 'storage/views/Ancients/BestSkips.gosql')
| -rw-r--r-- | storage/views/Ancients/BestSkips.gosql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/storage/views/Ancients/BestSkips.gosql b/storage/views/Ancients/BestSkips.gosql new file mode 100644 index 0000000..0b926c1 --- /dev/null +++ b/storage/views/Ancients/BestSkips.gosql @@ -0,0 +1,17 @@ +SELECT + AVG(ActIndex) + 1 AS Act, + Character, + Key, + Sum(Win) as Wins, + Count(*) - Sum(Win) as Losses, + ROUND(Wins / Count(*), 2) as Winrate, +FROM + AncientChoice +WHERE + Chosen = FALSE +GROUP BY + Character, + Key, + ActName +ORDER BY + Wins * Winrate DESC
\ No newline at end of file |