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 8612 5038 3574 58.50% 2.74% 57.46%
BananaFarm 41468 22923 18545 55.28% 13.17% 54.80%
MonkeyAce 6649 3712 2937 55.83% 2.11% 54.63%
BombShooter 11990 6400 5590 53.38% 3.81% 52.48%
DartMonkey 17404 9259 8145 53.20% 5.53% 52.46%
IceMonkey 9490 5020 4470 52.90% 3.01% 51.89%
EngineerMonkey 6094 3222 2872 52.87% 1.94% 51.62%
MonkeySub 10597 5560 5037 52.47% 3.37% 51.52%
BoomerangMonkey 10268 5265 5003 51.28% 3.26% 50.31%
SpikeFactory 21829 10945 10884 50.14% 6.93% 49.48%
TackShooter 18378 8999 9379 48.97% 5.84% 48.24%
Alchemist 11630 5700 5930 49.01% 3.69% 48.10%
DartlingGunner 11321 5524 5797 48.79% 3.60% 47.87%
GlueGunner 20143 9592 10551 47.62% 6.40% 46.93%
MonkeyBuccaneer 8916 4268 4648 47.87% 2.83% 46.83%
Druid 9159 4350 4809 47.49% 2.91% 46.47%
MonkeyVillage 21179 9902 11277 46.75% 6.73% 46.08%
WizardMonkey 18160 8486 9674 46.73% 5.77% 46.00%
HeliPilot 6708 3106 3602 46.30% 2.13% 45.11%
SniperMonkey 18229 8214 10015 45.06% 5.79% 44.34%
NinjaMonkey 13389 6014 7375 44.92% 4.25% 44.07%
SuperMonkey 13171 5893 7278 44.74% 4.18% 43.89%

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;