building_site_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 4996 2863 2133 57.31% 10.88% 55.93%
DartMonkey 4818 2729 2089 56.64% 10.49% 55.24%
BananaFarm 10222 5581 4641 54.60% 22.26% 53.63%
TackShooter 6140 3227 2913 52.56% 13.37% 51.31%
WizardMonkey 4549 2279 2270 50.10% 9.91% 48.65%
SpikeFactory 1118 534 584 47.76% 2.43% 44.84%
SniperMonkey 2370 1044 1326 44.05% 5.16% 42.05%
GlueGunner 1629 704 925 43.22% 3.55% 40.81%
BombShooter 605 269 336 44.46% 1.32% 40.50%
MonkeyBuccaneer 534 235 299 44.01% 1.16% 39.80%
IceMonkey 654 282 372 43.12% 1.42% 39.32%
BoomerangMonkey 1208 507 701 41.97% 2.63% 39.19%
EngineerMonkey 481 208 273 43.24% 1.05% 38.82%
NinjaMonkey 1212 496 716 40.92% 2.64% 38.16%
HeliPilot 1025 417 608 40.68% 2.23% 37.68%
Alchemist 741 294 447 39.68% 1.61% 36.15%
MonkeySub 635 242 393 38.11% 1.38% 34.33%
DartlingGunner 411 158 253 38.44% 0.89% 33.74%
SuperMonkey 610 224 386 36.72% 1.33% 32.90%
MonkeyAce 761 276 485 36.27% 1.66% 32.85%
MonkeyVillage 827 273 554 33.01% 1.80% 29.81%
Druid 378 120 258 31.75% 0.82% 27.05%

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;