inflection_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartlingGunner 586 329 257 56.14% 7.97% 52.13%
DartMonkey 833 458 375 54.98% 11.33% 51.60%
SpikeFactory 1099 585 514 53.23% 14.95% 50.28%
BananaFarm 1544 809 735 52.40% 21.01% 49.91%
SuperMonkey 181 102 79 56.35% 2.46% 49.13%
BoomerangMonkey 276 149 127 53.99% 3.76% 48.11%
MortarMonkey 90 50 40 55.56% 1.22% 45.29%
NinjaMonkey 235 117 118 49.79% 3.20% 43.39%
MonkeyVillage 184 92 92 50.00% 2.50% 42.78%
MonkeySub 297 139 158 46.80% 4.04% 41.13%
Alchemist 241 114 127 47.30% 3.28% 41.00%
EngineerMonkey 139 67 72 48.20% 1.89% 39.89%
WizardMonkey 429 177 252 41.26% 5.84% 36.60%
GlueGunner 106 47 59 44.34% 1.44% 34.88%
SniperMonkey 294 119 175 40.48% 4.00% 34.87%
Druid 89 40 49 44.94% 1.21% 34.61%
TackShooter 215 87 128 40.47% 2.93% 33.90%
HeliPilot 95 39 56 41.05% 1.29% 31.16%
MonkeyBuccaneer 143 56 87 39.16% 1.95% 31.16%
IceMonkey 172 62 110 36.05% 2.34% 28.87%
BombShooter 59 21 38 35.59% 0.80% 23.38%
MonkeyAce 43 16 27 37.21% 0.59% 22.76%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW inflection_towers AS 
WITH inflection AS
    (SELECT *
    FROM matches
    WHERE map = 'inflection')
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 inflection) * 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 inflection
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM inflection
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM inflection
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM inflection
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM inflection
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM inflection)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;