From 094846c15f4148c166ac297e26a1248bab0ab5c7 Mon Sep 17 00:00:00 2001
From: ewy <ewy0@protonmail.com>
Date: Fri, 22 May 2026 20:06:56 +0200
Subject: add views, expand api, add windows opening thing override

---
 storage/views/Ancients/BestSkips.gosql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 storage/views/Ancients/BestSkips.gosql

(limited to 'storage/views/Ancients/BestSkips.gosql')

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
-- 
cgit v1.3.1