building_site_scene_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 613 372 241 60.69% 11.84% 56.82%
DartMonkey 674 404 270 59.94% 13.02% 56.24%
BananaFarm 1030 594 436 57.67% 19.89% 54.65%
TackShooter 567 271 296 47.80% 10.95% 43.68%
SpikeFactory 160 80 80 50.00% 3.09% 42.25%
WizardMonkey 322 144 178 44.72% 6.22% 39.29%
EngineerMonkey 66 33 33 50.00% 1.27% 37.94%
MonkeyBuccaneer 88 41 47 46.59% 1.70% 36.17%
SniperMonkey 318 130 188 40.88% 6.14% 35.48%
GlueGunner 269 109 160 40.52% 5.20% 34.65%
MonkeySub 66 30 36 45.45% 1.27% 33.44%
BoomerangMonkey 123 51 72 41.46% 2.38% 32.76%
MonkeyAce 86 37 49 43.02% 1.66% 32.56%
BombShooter 73 32 41 43.84% 1.41% 32.45%
HeliPilot 103 42 61 40.78% 1.99% 31.29%
SuperMonkey 92 36 56 39.13% 1.78% 29.16%
IceMonkey 65 26 39 40.00% 1.26% 28.09%
DartlingGunner 58 23 35 39.66% 1.12% 27.07%
Alchemist 108 38 70 35.19% 2.09% 26.18%
MonkeyVillage 120 38 82 31.67% 2.32% 23.34%
Druid 56 20 36 35.71% 1.08% 23.16%
NinjaMonkey 121 38 83 31.40% 2.34% 23.13%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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