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
MortarMonkey 269 170 99 63.20% 1.30% 57.43%
BananaFarm 1547 846 701 54.69% 7.46% 52.21%
Alchemist 1253 686 567 54.75% 6.04% 51.99%
MonkeyBuccaneer 1534 818 716 53.32% 7.40% 50.83%
BombShooter 614 336 278 54.72% 2.96% 50.79%
DartMonkey 882 475 407 53.85% 4.25% 50.56%
SpikeFactory 2078 1095 983 52.69% 10.02% 50.55%
DartlingGunner 902 470 432 52.11% 4.35% 48.85%
IceMonkey 1078 543 535 50.37% 5.20% 47.39%
MonkeySub 748 381 367 50.94% 3.61% 47.35%
GlueGunner 1009 502 507 49.75% 4.87% 46.67%
BoomerangMonkey 612 304 308 49.67% 2.95% 45.71%
MonkeyVillage 1583 761 822 48.07% 7.63% 45.61%
SniperMonkey 1288 622 666 48.29% 6.21% 45.56%
SuperMonkey 1192 545 647 45.72% 5.75% 42.89%
Druid 582 273 309 46.91% 2.81% 42.85%
TackShooter 880 397 483 45.11% 4.24% 41.83%
NinjaMonkey 827 368 459 44.50% 3.99% 41.11%
HeliPilot 437 191 246 43.71% 2.11% 39.06%
WizardMonkey 1042 433 609 41.55% 5.03% 38.56%
MonkeyAce 104 45 59 43.27% 0.50% 33.75%
EngineerMonkey 275 107 168 38.91% 1.33% 33.15%

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;