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/Cards/Best.gosql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 storage/views/Cards/Best.gosql

(limited to 'storage/views/Cards')

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