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 3593 2187 1406 60.87% 5.38% 59.27%
BananaFarm 13977 7686 6291 54.99% 20.94% 54.17%
BombShooter 7214 3986 3228 55.25% 10.81% 54.11%
TackShooter 9709 5163 4546 53.18% 14.55% 52.18%
SpikeFactory 6356 3284 3072 51.67% 9.52% 50.44%
WizardMonkey 6766 3416 3350 50.49% 10.14% 49.30%
MonkeyAce 765 399 366 52.16% 1.15% 48.62%
MonkeySub 2192 1043 1149 47.58% 3.28% 45.49%
EngineerMonkey 672 319 353 47.47% 1.01% 43.69%
IceMonkey 1278 546 732 42.72% 1.91% 40.01%
HeliPilot 1371 572 799 41.72% 2.05% 39.11%
SniperMonkey 2222 906 1316 40.77% 3.33% 38.73%
GlueGunner 2092 818 1274 39.10% 3.13% 37.01%
MonkeyBuccaneer 769 309 460 40.18% 1.15% 36.72%
DartMonkey 792 305 487 38.51% 1.19% 35.12%
MonkeyVillage 1511 535 976 35.41% 2.26% 33.00%
SuperMonkey 1111 398 713 35.82% 1.66% 33.00%
Druid 632 232 400 36.71% 0.95% 32.95%
NinjaMonkey 1531 524 1007 34.23% 2.29% 31.85%
Alchemist 779 274 505 35.17% 1.17% 31.82%
BoomerangMonkey 1011 347 664 34.32% 1.51% 31.40%
DartlingGunner 401 123 278 30.67% 0.60% 26.16%

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;