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 1067 605 462 56.70% 5.49% 53.73%
BombShooter 758 432 326 56.99% 3.90% 53.47%
Alchemist 1025 575 450 56.10% 5.28% 53.06%
MonkeySub 1225 670 555 54.69% 6.31% 51.91%
MonkeyBuccaneer 1127 612 515 54.30% 5.80% 51.40%
BananaFarm 2149 1143 1006 53.19% 11.06% 51.08%
SpikeFactory 1705 874 831 51.26% 8.78% 48.89%
HeliPilot 548 279 269 50.91% 2.82% 46.73%
DartMonkey 459 233 226 50.76% 2.36% 46.19%
MonkeyVillage 1337 642 695 48.02% 6.88% 45.34%
DartlingGunner 918 438 480 47.71% 4.73% 44.48%
Druid 471 230 241 48.83% 2.43% 44.32%
NinjaMonkey 759 363 396 47.83% 3.91% 44.27%
SuperMonkey 1148 535 613 46.60% 5.91% 43.72%
MortarMonkey 173 85 88 49.13% 0.89% 41.68%
BoomerangMonkey 647 292 355 45.13% 3.33% 41.30%
EngineerMonkey 277 130 147 46.93% 1.43% 41.05%
SniperMonkey 854 379 475 44.38% 4.40% 41.05%
TackShooter 909 402 507 44.22% 4.68% 41.00%
GlueGunner 745 329 416 44.16% 3.84% 40.60%
WizardMonkey 1021 431 590 42.21% 5.26% 39.18%
MonkeyAce 100 32 68 32.00% 0.51% 22.86%

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;