bloon_bot_factory_towers (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 1418 768 650 54.16% 22.92% 51.57%
GlueGunner 430 240 190 55.81% 6.95% 51.12%
Alchemist 206 119 87 57.77% 3.33% 51.02%
HeliPilot 1226 646 580 52.69% 19.82% 49.90%
TackShooter 131 74 57 56.49% 2.12% 48.00%
SuperMonkey 176 97 79 55.11% 2.85% 47.77%
MonkeyVillage 179 90 89 50.28% 2.89% 42.95%
BombShooter 66 36 30 54.55% 1.07% 42.53%
MonkeyBuccaneer 483 224 259 46.38% 7.81% 41.93%
SniperMonkey 403 184 219 45.66% 6.51% 40.79%
MonkeySub 143 68 75 47.55% 2.31% 39.37%
MonkeyAce 492 214 278 43.50% 7.95% 39.12%
BananaFarm 188 84 104 44.68% 3.04% 37.57%
DartlingGunner 181 80 101 44.20% 2.93% 36.96%
EngineerMonkey 42 20 22 47.62% 0.68% 32.51%
SpikeFactory 106 40 66 37.74% 1.71% 28.51%
DartMonkey 60 23 37 38.33% 0.97% 26.03%
BoomerangMonkey 42 17 25 40.48% 0.68% 25.63%
WizardMonkey 108 37 71 34.26% 1.75% 25.31%
NinjaMonkey 58 19 39 32.76% 0.94% 20.68%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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