bloon_bot_factory_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
GlueGunner 2860 1666 1194 58.25% 6.18% 56.44%
BombShooter 722 420 302 58.17% 1.56% 54.57%
MortarMonkey 10755 5935 4820 55.18% 23.25% 54.24%
Alchemist 1672 941 731 56.28% 3.61% 53.90%
SuperMonkey 1224 669 555 54.66% 2.65% 51.87%
HeliPilot 8690 4598 4092 52.91% 18.78% 51.86%
TackShooter 1216 648 568 53.29% 2.63% 50.49%
MonkeyBuccaneer 3836 1856 1980 48.38% 8.29% 46.80%
MonkeyVillage 1078 516 562 47.87% 2.33% 44.88%
MonkeyAce 3567 1646 1921 46.15% 7.71% 44.51%
EngineerMonkey 465 217 248 46.67% 1.01% 42.13%
BananaFarm 1930 845 1085 43.78% 4.17% 41.57%
SniperMonkey 2838 1154 1684 40.66% 6.13% 38.86%
SpikeFactory 739 309 430 41.81% 1.60% 38.26%
DartlingGunner 1158 471 687 40.67% 2.50% 37.84%
MonkeySub 1175 460 715 39.15% 2.54% 36.36%
WizardMonkey 832 295 537 35.46% 1.80% 32.21%
BoomerangMonkey 325 113 212 34.77% 0.70% 29.59%
DartMonkey 319 103 216 32.29% 0.69% 27.16%
NinjaMonkey 427 133 294 31.15% 0.92% 26.76%
Druid 215 70 145 32.56% 0.46% 26.29%
IceMonkey 223 68 155 30.49% 0.48% 24.45%

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;