storage/views/Ancients/BestSkips.gosql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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