add views, expand api, add windows opening thing overridemain

1 files changed, 18 insertions, 0 deletions

diff --git a/storage/views/Ancients/Best.gosql b/storage/views/Ancients/Best.gosql
new file mode 100644
index 0000000..bd87658
--- /dev/null
+++ b/storage/views/Ancients/Best.gosql
@@ -0,0 +1,18 @@
+SELECT
+    AVG(ActIndex) + 1 AS Act,
+    Character,
+    Key,
+    Count(*) AS Amount,
+    Sum(Win) AS Wins,
+    Amount - Sum(Win) AS Losses,
+    ROUND(Wins / Amount, 2) as Winrate,
+FROM
+    AncientChoice
+WHERE
+    Chosen = TRUE,
+GROUP BY
+    Character,
+    Key,
+    ActName,
+ORDER BY
+    Wins
\ No newline at end of file