times_up_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 4967 2791 2176 56.19% 7.22% 54.81%
MortarMonkey 2493 1391 1102 55.80% 3.62% 53.85%
TackShooter 12992 7058 5934 54.33% 18.89% 53.47%
BananaFarm 14789 7923 6866 53.57% 21.50% 52.77%
GlueGunner 3392 1699 1693 50.09% 4.93% 48.41%
BombShooter 2597 1291 1306 49.71% 3.78% 47.79%
BoomerangMonkey 2117 1049 1068 49.55% 3.08% 47.42%
WizardMonkey 6262 2999 3263 47.89% 9.10% 46.65%
NinjaMonkey 2303 1099 1204 47.72% 3.35% 45.68%
MonkeySub 4022 1893 2129 47.07% 5.85% 45.52%
SniperMonkey 2900 1266 1634 43.66% 4.22% 41.85%
DartMonkey 866 380 486 43.88% 1.26% 40.57%
MonkeyBuccaneer 1338 577 761 43.12% 1.95% 40.47%
EngineerMonkey 561 234 327 41.71% 0.82% 37.63%
Alchemist 770 313 457 40.65% 1.12% 37.18%
MonkeyVillage 1806 705 1101 39.04% 2.63% 36.79%
HeliPilot 843 332 511 39.38% 1.23% 36.08%
DartlingGunner 537 206 331 38.36% 0.78% 34.25%
Druid 915 342 573 37.38% 1.33% 34.24%
MonkeyAce 373 144 229 38.61% 0.54% 33.67%
SuperMonkey 1121 407 714 36.31% 1.63% 33.49%
SpikeFactory 820 293 527 35.73% 1.19% 32.45%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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