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 9220 5296 3924 57.44% 2.73% 56.43%
MortarMonkey 8527 4740 3787 55.59% 2.52% 54.53%
DartMonkey 11853 6505 5348 54.88% 3.51% 53.98%
EngineerMonkey 9354 5100 4254 54.52% 2.77% 53.51%
BananaFarm 62483 33664 28819 53.88% 18.49% 53.49%
BombShooter 14149 7555 6594 53.40% 4.19% 52.57%
IceMonkey 10184 5365 4819 52.68% 3.01% 51.71%
MonkeySub 18662 9618 9044 51.54% 5.52% 50.82%
SpikeFactory 20846 10462 10384 50.19% 6.17% 49.51%
TackShooter 23945 11820 12125 49.36% 7.09% 48.73%
BoomerangMonkey 13660 6714 6946 49.15% 4.04% 48.31%
Alchemist 9435 4524 4911 47.95% 2.79% 46.94%
GlueGunner 14386 6795 7591 47.23% 4.26% 46.42%
WizardMonkey 22789 10657 12132 46.76% 6.74% 46.12%
MonkeyBuccaneer 6734 3170 3564 47.07% 1.99% 45.88%
DartlingGunner 11283 5261 6022 46.63% 3.34% 45.71%
HeliPilot 8204 3835 4369 46.75% 2.43% 45.67%
Druid 8991 4195 4796 46.66% 2.66% 45.63%
MonkeyVillage 15963 7328 8635 45.91% 4.72% 45.13%
NinjaMonkey 12543 5588 6955 44.55% 3.71% 43.68%
SniperMonkey 13479 5876 7603 43.59% 3.99% 42.76%
SuperMonkey 11254 4904 6350 43.58% 3.33% 42.66%

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;