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 9893 5596 4297 56.57% 2.89% 55.59%
BananaFarm 47899 25979 21920 54.24% 14.00% 53.79%
IceMonkey 9623 5239 4384 54.44% 2.81% 53.45%
MonkeyAce 8102 4401 3701 54.32% 2.37% 53.24%
DartMonkey 17267 9124 8143 52.84% 5.05% 52.10%
EngineerMonkey 6848 3588 3260 52.39% 2.00% 51.21%
BombShooter 13039 6778 6261 51.98% 3.81% 51.12%
BoomerangMonkey 10850 5594 5256 51.56% 3.17% 50.62%
MonkeySub 11969 6104 5865 51.00% 3.50% 50.10%
SpikeFactory 22260 11076 11184 49.76% 6.51% 49.10%
TackShooter 21061 10445 10616 49.59% 6.15% 48.92%
DartlingGunner 14854 7364 7490 49.58% 4.34% 48.77%
MonkeyVillage 21385 10473 10912 48.97% 6.25% 48.30%
GlueGunner 20293 9835 10458 48.46% 5.93% 47.78%
Alchemist 11930 5718 6212 47.93% 3.49% 47.03%
WizardMonkey 19480 9215 10265 47.30% 5.69% 46.60%
SuperMonkey 15890 7504 8386 47.22% 4.64% 46.45%
HeliPilot 9819 4587 5232 46.72% 2.87% 45.73%
MonkeyBuccaneer 10327 4809 5518 46.57% 3.02% 45.61%
Druid 7973 3677 4296 46.12% 2.33% 45.02%
SniperMonkey 18544 8324 10220 44.89% 5.42% 44.17%
NinjaMonkey 12886 5666 7220 43.97% 3.77% 43.11%

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;