all_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 63876 36272 27604 56.79% 2.55% 56.40%
MonkeyAce 59743 32962 26781 55.17% 2.38% 54.77%
BananaFarm 413672 223548 190124 54.04% 16.51% 53.89%
DartMonkey 104053 55477 48576 53.32% 4.15% 53.01%
EngineerMonkey 57180 30523 26657 53.38% 2.28% 52.97%
BombShooter 88650 47165 41485 53.20% 3.54% 52.88%
MonkeySub 120354 62254 58100 51.73% 4.80% 51.44%
IceMonkey 87411 45049 42362 51.54% 3.49% 51.21%
BoomerangMonkey 89880 45568 44312 50.70% 3.59% 50.37%
SpikeFactory 160345 80423 79922 50.16% 6.40% 49.91%
TackShooter 169702 84374 85328 49.72% 6.77% 49.48%
Alchemist 77264 37497 39767 48.53% 3.08% 48.18%
DartlingGunner 95329 46173 49156 48.44% 3.80% 48.12%
WizardMonkey 172439 83211 89228 48.26% 6.88% 48.02%
GlueGunner 117298 55748 61550 47.53% 4.68% 47.24%
MonkeyVillage 130386 61569 68817 47.22% 5.20% 46.95%
MonkeyBuccaneer 60433 28221 32212 46.70% 2.41% 46.30%
Druid 60166 27944 32222 46.44% 2.40% 46.05%
HeliPilot 59213 27341 31872 46.17% 2.36% 45.77%
SuperMonkey 94387 42605 51782 45.14% 3.77% 44.82%
NinjaMonkey 99146 44459 54687 44.84% 3.96% 44.53%
SniperMonkey 125135 54648 70487 43.67% 4.99% 43.40%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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