precious_space_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BombShooter 826 494 332 59.81% 6.98% 56.46%
MonkeySub 1480 867 613 58.58% 12.50% 56.07%
BananaFarm 2534 1398 1136 55.17% 21.41% 53.23%
MortarMonkey 148 84 64 56.76% 1.25% 48.78%
MonkeyAce 141 78 63 55.32% 1.19% 47.11%
DartlingGunner 728 365 363 50.14% 6.15% 46.51%
BoomerangMonkey 562 277 285 49.29% 4.75% 45.15%
SpikeFactory 748 354 394 47.33% 6.32% 43.75%
SuperMonkey 343 167 176 48.69% 2.90% 43.40%
Alchemist 303 140 163 46.20% 2.56% 40.59%
NinjaMonkey 431 192 239 44.55% 3.64% 39.86%
MonkeyVillage 320 144 176 45.00% 2.70% 39.55%
Druid 238 107 131 44.96% 2.01% 38.64%
TackShooter 477 204 273 42.77% 4.03% 38.33%
IceMonkey 344 147 197 42.73% 2.91% 37.50%
WizardMonkey 676 278 398 41.12% 5.71% 37.41%
SniperMonkey 616 251 365 40.75% 5.20% 36.87%
GlueGunner 254 108 146 42.52% 2.15% 36.44%
MonkeyBuccaneer 232 90 142 38.79% 1.96% 32.52%
EngineerMonkey 143 58 85 40.56% 1.21% 32.51%
DartMonkey 104 43 61 41.35% 0.88% 31.88%
HeliPilot 190 73 117 38.42% 1.61% 31.50%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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