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 8501 4758 3743 55.97% 2.89% 54.91%
BananaFarm 44787 24298 20489 54.25% 15.25% 53.79%
DartMonkey 12633 6846 5787 54.19% 4.30% 53.32%
IceMonkey 11245 6061 5184 53.90% 3.83% 52.98%
BombShooter 9726 5123 4603 52.67% 3.31% 51.68%
MonkeyAce 6817 3587 3230 52.62% 2.32% 51.43%
EngineerMonkey 6734 3523 3211 52.32% 2.29% 51.12%
MonkeySub 10961 5662 5299 51.66% 3.73% 50.72%
BoomerangMonkey 9965 5078 4887 50.96% 3.39% 49.98%
TackShooter 19102 9651 9451 50.52% 6.50% 49.81%
SpikeFactory 18649 9399 9250 50.40% 6.35% 49.68%
Alchemist 8962 4399 4563 49.09% 3.05% 48.05%
GlueGunner 15811 7660 8151 48.45% 5.38% 47.67%
MonkeyVillage 16944 8199 8745 48.39% 5.77% 47.64%
DartlingGunner 12833 6164 6669 48.03% 4.37% 47.17%
WizardMonkey 17183 8141 9042 47.38% 5.85% 46.63%
HeliPilot 9682 4567 5115 47.17% 3.30% 46.18%
MonkeyBuccaneer 7691 3595 4096 46.74% 2.62% 45.63%
SuperMonkey 13647 6212 7435 45.52% 4.65% 44.68%
Druid 6848 3134 3714 45.77% 2.33% 44.59%
NinjaMonkey 10665 4653 6012 43.63% 3.63% 42.69%
SniperMonkey 14374 6170 8204 42.92% 4.89% 42.12%

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;