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 5981 3402 2579 56.88% 2.10% 55.62%
MonkeyAce 7070 3993 3077 56.48% 2.48% 55.32%
EngineerMonkey 6998 3870 3128 55.30% 2.45% 54.14%
BananaFarm 56257 30081 26176 53.47% 19.73% 53.06%
MonkeySub 19617 10356 9261 52.79% 6.88% 52.09%
BombShooter 8826 4655 4171 52.74% 3.10% 51.70%
DartMonkey 7668 4008 3660 52.27% 2.69% 51.15%
IceMonkey 14726 7470 7256 50.73% 5.16% 49.92%
TackShooter 20219 10046 10173 49.69% 7.09% 49.00%
SpikeFactory 16335 8090 8245 49.53% 5.73% 48.76%
DartlingGunner 11153 5483 5670 49.16% 3.91% 48.23%
WizardMonkey 21769 10588 11181 48.64% 7.63% 47.97%
BoomerangMonkey 10869 5269 5600 48.48% 3.81% 47.54%
MonkeyVillage 12106 5715 6391 47.21% 4.25% 46.32%
Druid 5273 2474 2799 46.92% 1.85% 45.57%
Alchemist 6495 3028 3467 46.62% 2.28% 45.41%
NinjaMonkey 12770 5903 6867 46.23% 4.48% 45.36%
GlueGunner 8402 3892 4510 46.32% 2.95% 45.26%
HeliPilot 6253 2861 3392 45.75% 2.19% 44.52%
SuperMonkey 7719 3460 4259 44.82% 2.71% 43.72%
MonkeyBuccaneer 4505 1986 2519 44.08% 1.58% 42.63%
SniperMonkey 14127 5939 8188 42.04% 4.95% 41.23%

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;