glade_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 9646 5437 4209 56.37% 12.77% 55.38%
MortarMonkey 1806 1041 765 57.64% 2.39% 55.36%
BananaFarm 15024 8233 6791 54.80% 19.89% 54.00%
SpikeFactory 11248 6136 5112 54.55% 14.89% 53.63%
BoomerangMonkey 4775 2349 2426 49.19% 6.32% 47.78%
IceMonkey 1294 636 658 49.15% 1.71% 46.43%
MonkeySub 2289 1093 1196 47.75% 3.03% 45.70%
DartlingGunner 2762 1307 1455 47.32% 3.66% 45.46%
WizardMonkey 4513 2058 2455 45.60% 5.98% 44.15%
TackShooter 2642 1202 1440 45.50% 3.50% 43.60%
Alchemist 1805 800 1005 44.32% 2.39% 42.03%
GlueGunner 2747 1179 1568 42.92% 3.64% 41.07%
SniperMonkey 3461 1471 1990 42.50% 4.58% 40.86%
SuperMonkey 1767 761 1006 43.07% 2.34% 40.76%
NinjaMonkey 2361 996 1365 42.19% 3.13% 40.19%
MonkeyBuccaneer 1166 501 665 42.97% 1.54% 40.13%
HeliPilot 1010 436 574 43.17% 1.34% 40.11%
BombShooter 855 371 484 43.39% 1.13% 40.07%
EngineerMonkey 929 401 528 43.16% 1.23% 39.98%
MonkeyVillage 2001 809 1192 40.43% 2.65% 38.28%
Druid 988 392 596 39.68% 1.31% 36.63%
MonkeyAce 433 152 281 35.10% 0.57% 30.61%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW glade_towers AS 
WITH glade AS
    (SELECT *
    FROM matches
    WHERE map = 'glade')
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 glade) * 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 glade
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM glade
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM glade
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM glade
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM glade
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM glade)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;