banana_depot_scene_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 458 282 176 61.57% 5.94% 57.12%
BananaFarm 1407 784 623 55.72% 18.25% 53.13%
BombShooter 737 416 321 56.45% 9.56% 52.87%
TackShooter 1060 573 487 54.06% 13.75% 51.06%
SpikeFactory 753 390 363 51.79% 9.77% 48.22%
MonkeyAce 85 47 38 55.29% 1.10% 44.72%
WizardMonkey 599 291 308 48.58% 7.77% 44.58%
MonkeySub 216 109 107 50.46% 2.80% 43.80%
IceMonkey 147 69 78 46.94% 1.91% 38.87%
GlueGunner 404 174 230 43.07% 5.24% 38.24%
HeliPilot 145 66 79 45.52% 1.88% 37.41%
SniperMonkey 309 129 180 41.75% 4.01% 36.25%
EngineerMonkey 69 33 36 47.83% 0.89% 36.04%
SuperMonkey 161 69 92 42.86% 2.09% 35.21%
DartlingGunner 59 27 32 45.76% 0.77% 33.05%
DartMonkey 161 63 98 39.13% 2.09% 31.59%
MonkeyVillage 241 87 154 36.10% 3.13% 30.04%
MonkeyBuccaneer 120 46 74 38.33% 1.56% 29.63%
NinjaMonkey 211 74 137 35.07% 2.74% 28.63%
Alchemist 138 47 91 34.06% 1.79% 26.15%
BoomerangMonkey 136 46 90 33.82% 1.76% 25.87%
Druid 94 33 61 35.11% 1.22% 25.46%

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;