mayan_map_01_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
GlueGunner 816 457 359 56.00% 8.76% 52.60%
TackShooter 955 526 429 55.08% 10.25% 51.92%
BoomerangMonkey 306 174 132 56.86% 3.28% 51.31%
MonkeyVillage 916 480 436 52.40% 9.83% 49.17%
WizardMonkey 730 383 347 52.47% 7.83% 48.84%
DartMonkey 327 176 151 53.82% 3.51% 48.42%
BananaFarm 849 427 422 50.29% 9.11% 46.93%
MonkeySub 104 58 46 55.77% 1.12% 46.22%
MortarMonkey 99 55 44 55.56% 1.06% 45.77%
SniperMonkey 715 342 373 47.83% 7.67% 44.17%
SuperMonkey 588 277 311 47.11% 6.31% 43.07%
BombShooter 224 110 114 49.11% 2.40% 42.56%
HeliPilot 255 123 132 48.24% 2.74% 42.10%
IceMonkey 236 114 122 48.31% 2.53% 41.93%
NinjaMonkey 556 249 307 44.78% 5.97% 40.65%
MonkeyBuccaneer 154 74 80 48.05% 1.65% 40.16%
Alchemist 244 111 133 45.49% 2.62% 39.24%
SpikeFactory 371 159 212 42.86% 3.98% 37.82%
DartlingGunner 450 190 260 42.22% 4.83% 37.66%
MonkeyAce 107 49 58 45.79% 1.15% 36.35%
Druid 196 81 115 41.33% 2.10% 34.43%
EngineerMonkey 120 44 76 36.67% 1.29% 28.04%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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