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 6155 3397 2758 55.19% 1.99% 53.95%
BananaFarm 56944 30550 26394 53.65% 18.38% 53.24%
BombShooter 8696 4637 4059 53.32% 2.81% 52.27%
MonkeyAce 8447 4501 3946 53.29% 2.73% 52.22%
EngineerMonkey 10062 5265 4797 52.33% 3.25% 51.35%
DartMonkey 8207 4286 3921 52.22% 2.65% 51.14%
BoomerangMonkey 11706 6060 5646 51.77% 3.78% 50.86%
DartlingGunner 14348 7325 7023 51.05% 4.63% 50.23%
SpikeFactory 17754 9032 8722 50.87% 5.73% 50.14%
WizardMonkey 27854 14032 13822 50.38% 8.99% 49.79%
TackShooter 24023 12043 11980 50.13% 7.76% 49.50%
MonkeySub 13831 6902 6929 49.90% 4.46% 49.07%
Alchemist 7781 3873 3908 49.78% 2.51% 48.66%
IceMonkey 12059 5894 6165 48.88% 3.89% 47.98%
NinjaMonkey 12333 5757 6576 46.68% 3.98% 45.80%
MonkeyVillage 14960 6932 8028 46.34% 4.83% 45.54%
SuperMonkey 11158 5158 6000 46.23% 3.60% 45.30%
Druid 5962 2732 3230 45.82% 1.92% 44.56%
MonkeyBuccaneer 6602 2988 3614 45.26% 2.13% 44.06%
HeliPilot 7922 3548 4374 44.79% 2.56% 43.69%
SniperMonkey 14642 6374 8268 43.53% 4.73% 42.73%
GlueGunner 8328 3601 4727 43.24% 2.69% 42.18%

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;