bloon_bot_factory_towers (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
SuperMonkey 149 91 58 61.07% 2.45% 53.24%
MortarMonkey 1472 809 663 54.96% 24.22% 52.42%
GlueGunner 322 182 140 56.52% 5.30% 51.11%
BombShooter 106 64 42 60.38% 1.74% 51.07%
Alchemist 244 131 113 53.69% 4.01% 47.43%
TackShooter 227 122 105 53.74% 3.73% 47.26%
EngineerMonkey 86 49 37 56.98% 1.41% 46.51%
HeliPilot 1089 538 551 49.40% 17.92% 46.43%
MonkeyBuccaneer 516 261 255 50.58% 8.49% 46.27%
MonkeyVillage 92 51 41 55.43% 1.51% 45.28%
MonkeyAce 451 214 237 47.45% 7.42% 42.84%
BananaFarm 333 153 180 45.95% 5.48% 40.59%
DartlingGunner 137 62 75 45.26% 2.25% 36.92%
SniperMonkey 301 120 181 39.87% 4.95% 34.34%
SpikeFactory 102 44 58 43.14% 1.68% 33.53%
BoomerangMonkey 48 22 26 45.83% 0.79% 31.74%
MonkeySub 166 56 110 33.73% 2.73% 26.54%
NinjaMonkey 49 19 30 38.78% 0.81% 25.13%
WizardMonkey 115 36 79 31.30% 1.89% 22.83%

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;