all_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 7801 4502 3299 57.71% 2.50% 56.61%
MortarMonkey 7963 4505 3458 56.57% 2.55% 55.49%
EngineerMonkey 7528 4176 3352 55.47% 2.41% 54.35%
BananaFarm 63499 34282 29217 53.99% 20.34% 53.60%
DartMonkey 9466 5050 4416 53.35% 3.03% 52.34%
BombShooter 11683 6174 5509 52.85% 3.74% 51.94%
MonkeySub 24734 12907 11827 52.18% 7.92% 51.56%
BoomerangMonkey 11999 6072 5927 50.60% 3.84% 49.71%
IceMonkey 13831 6920 6911 50.03% 4.43% 49.20%
SpikeFactory 18891 9417 9474 49.85% 6.05% 49.14%
TackShooter 22287 11034 11253 49.51% 7.14% 48.85%
WizardMonkey 23001 11219 11782 48.78% 7.37% 48.13%
Druid 7993 3797 4196 47.50% 2.56% 46.41%
DartlingGunner 10149 4747 5402 46.77% 3.25% 45.80%
GlueGunner 9183 4257 4926 46.36% 2.94% 45.34%
Alchemist 7162 3247 3915 45.34% 2.29% 44.18%
MonkeyVillage 11618 5229 6389 45.01% 3.72% 44.10%
MonkeyBuccaneer 5397 2403 2994 44.52% 1.73% 43.20%
NinjaMonkey 12475 5482 6993 43.94% 4.00% 43.07%
HeliPilot 4834 2103 2731 43.50% 1.55% 42.11%
SuperMonkey 7300 3103 4197 42.51% 2.34% 41.37%
SniperMonkey 13374 5458 7916 40.81% 4.28% 39.98%

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;