sands_of_time_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Winrate_LowerBound_95CI

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
EngineerMonkey 467 268 199 57.39% 2.62% 52.90%
BananaFarm 3407 1842 1565 54.07% 19.10% 52.39%
MonkeySub 1769 954 815 53.93% 9.92% 51.61%
IceMonkey 1473 778 695 52.82% 8.26% 50.27%
Druid 628 336 292 53.50% 3.52% 49.60%
MonkeyAce 252 138 114 54.76% 1.41% 48.62%
BoomerangMonkey 708 362 346 51.13% 3.97% 47.45%
DartlingGunner 877 439 438 50.06% 4.92% 46.75%
WizardMonkey 1190 562 628 47.23% 6.67% 44.39%
MonkeyVillage 986 461 525 46.75% 5.53% 43.64%
NinjaMonkey 938 434 504 46.27% 5.26% 43.08%
TackShooter 935 429 506 45.88% 5.24% 42.69%
HeliPilot 379 179 200 47.23% 2.12% 42.20%
SuperMonkey 636 293 343 46.07% 3.57% 42.20%
SniperMonkey 888 402 486 45.27% 4.98% 42.00%
DartMonkey 168 83 85 49.40% 0.94% 41.84%
MortarMonkey 93 48 45 51.61% 0.52% 41.46%
SpikeFactory 599 272 327 45.41% 3.36% 41.42%
GlueGunner 506 230 276 45.45% 2.84% 41.12%
BombShooter 338 156 182 46.15% 1.89% 40.84%
Alchemist 330 141 189 42.73% 1.85% 37.39%
MonkeyBuccaneer 271 112 159 41.33% 1.52% 35.47%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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