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