times_up_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 934 557 377 59.64% 9.60% 56.49%
TackShooter 2111 1131 980 53.58% 21.70% 51.45%
BananaFarm 2330 1233 1097 52.92% 23.96% 50.89%
GlueGunner 385 185 200 48.05% 3.96% 43.06%
BoomerangMonkey 278 135 143 48.56% 2.86% 42.69%
SniperMonkey 311 150 161 48.23% 3.20% 42.68%
MonkeyBuccaneer 119 61 58 51.26% 1.22% 42.28%
WizardMonkey 883 398 485 45.07% 9.08% 41.79%
MonkeySub 573 260 313 45.38% 5.89% 41.30%
NinjaMonkey 297 138 159 46.46% 3.05% 40.79%
MortarMonkey 250 117 133 46.80% 2.57% 40.61%
BombShooter 321 144 177 44.86% 3.30% 39.42%
SuperMonkey 114 55 59 48.25% 1.17% 39.07%
MonkeyVillage 225 86 139 38.22% 2.31% 31.87%
DartMonkey 82 31 51 37.80% 0.84% 27.31%
DartlingGunner 40 17 23 42.50% 0.41% 27.18%
Alchemist 76 28 48 36.84% 0.78% 26.00%
HeliPilot 96 34 62 35.42% 0.99% 25.85%
Druid 97 34 63 35.05% 1.00% 25.56%
MonkeyAce 36 15 21 41.67% 0.37% 25.56%
EngineerMonkey 73 26 47 35.62% 0.75% 24.63%
SpikeFactory 95 28 67 29.47% 0.98% 20.31%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW times_up_towers AS 
WITH times_up AS
    (SELECT *
    FROM matches
    WHERE map = 'times_up')
SELECT Tower,
       Games,
       Wins,
       Losses,
       printf('%.2f%%', WR * 100)                                          AS Winrate,
       printf('%.2f%%', PR * 100)                                          AS Pickrate,
       printf('%.2f%%', (WR - 1.96 * SQRT((WR * (1 - WR)) / Games)) * 100) AS Winrate_LowerBound_95CI
FROM (SELECT Tower,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM times_up) * 6)    AS PR
      FROM (SELECT Tower,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT lt1           AS Tower,
                         playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM times_up
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM times_up)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;