bloonstone_quarry_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 1539 826 713 53.67% 8.17% 51.18%
BananaFarm 2463 1302 1161 52.86% 13.08% 50.89%
MonkeySub 1403 750 653 53.46% 7.45% 50.85%
BombShooter 458 253 205 55.24% 2.43% 50.69%
Alchemist 648 347 301 53.55% 3.44% 49.71%
BoomerangMonkey 690 366 324 53.04% 3.66% 49.32%
MonkeyVillage 1406 711 695 50.57% 7.47% 47.96%
SpikeFactory 1431 721 710 50.38% 7.60% 47.79%
DartlingGunner 1014 515 499 50.79% 5.39% 47.71%
MonkeyBuccaneer 771 389 382 50.45% 4.09% 46.92%
DartMonkey 315 165 150 52.38% 1.67% 46.87%
SuperMonkey 941 457 484 48.57% 5.00% 45.37%
WizardMonkey 1183 558 625 47.17% 6.28% 44.32%
SniperMonkey 971 440 531 45.31% 5.16% 42.18%
NinjaMonkey 815 369 446 45.28% 4.33% 41.86%
MortarMonkey 129 65 64 50.39% 0.69% 41.76%
TackShooter 813 367 446 45.14% 4.32% 41.72%
Druid 350 164 186 46.86% 1.86% 41.63%
EngineerMonkey 393 178 215 45.29% 2.09% 40.37%
HeliPilot 506 226 280 44.66% 2.69% 40.33%
GlueGunner 433 184 249 42.49% 2.30% 37.84%
MonkeyAce 156 61 95 39.10% 0.83% 31.44%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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