precious_space_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 160 101 59 63.13% 1.29% 55.65%
BananaFarm 2475 1314 1161 53.09% 20.00% 51.12%
BombShooter 745 400 345 53.69% 6.02% 50.11%
DartlingGunner 1054 557 497 52.85% 8.52% 49.83%
BoomerangMonkey 627 329 298 52.47% 5.07% 48.56%
MonkeySub 1110 568 542 51.17% 8.97% 48.23%
SpikeFactory 681 351 330 51.54% 5.50% 47.79%
SuperMonkey 517 260 257 50.29% 4.18% 45.98%
NinjaMonkey 504 249 255 49.40% 4.07% 45.04%
WizardMonkey 839 400 439 47.68% 6.78% 44.30%
TackShooter 562 271 291 48.22% 4.54% 44.09%
MonkeyVillage 457 221 236 48.36% 3.69% 43.78%
HeliPilot 228 112 116 49.12% 1.84% 42.63%
Druid 243 117 126 48.15% 1.96% 41.87%
Alchemist 290 132 158 45.52% 2.34% 39.79%
SniperMonkey 633 275 358 43.44% 5.12% 39.58%
MonkeyBuccaneer 260 114 146 43.85% 2.10% 37.81%
GlueGunner 233 101 132 43.35% 1.88% 36.98%
DartMonkey 122 55 67 45.08% 0.99% 36.25%
EngineerMonkey 242 102 140 42.15% 1.96% 35.93%
IceMonkey 253 100 153 39.53% 2.04% 33.50%
MonkeyAce 137 57 80 41.61% 1.11% 33.35%

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;