banana_depot_scene_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 481 286 195 59.46% 5.06% 55.07%
BananaFarm 2182 1193 989 54.67% 22.94% 52.59%
BombShooter 1293 709 584 54.83% 13.60% 52.12%
SpikeFactory 1015 526 489 51.82% 10.67% 48.75%
TackShooter 1256 638 618 50.80% 13.21% 48.03%
WizardMonkey 907 456 451 50.28% 9.54% 47.02%
MonkeyAce 97 55 42 56.70% 1.02% 46.84%
MonkeySub 387 180 207 46.51% 4.07% 41.54%
EngineerMonkey 117 58 59 49.57% 1.23% 40.51%
DartMonkey 89 41 48 46.07% 0.94% 35.71%
GlueGunner 213 87 126 40.85% 2.24% 34.24%
MonkeyBuccaneer 82 36 46 43.90% 0.86% 33.16%
IceMonkey 175 68 107 38.86% 1.84% 31.64%
HeliPilot 160 61 99 38.13% 1.68% 30.60%
Druid 100 39 61 39.00% 1.05% 29.44%
SniperMonkey 242 85 157 35.12% 2.54% 29.11%
NinjaMonkey 178 62 116 34.83% 1.87% 27.83%
MonkeyVillage 174 60 114 34.48% 1.83% 27.42%
SuperMonkey 113 39 74 34.51% 1.19% 25.75%
BoomerangMonkey 147 44 103 29.93% 1.55% 22.53%
Alchemist 69 21 48 30.43% 0.73% 19.58%
DartlingGunner 33 11 22 33.33% 0.35% 17.25%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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