off_tide_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 2919 1626 1293 55.70% 16.69% 53.90%
MortarMonkey 640 367 273 57.34% 3.66% 53.51%
BoomerangMonkey 756 428 328 56.61% 4.32% 53.08%
DartMonkey 753 405 348 53.78% 4.31% 50.22%
IceMonkey 707 371 336 52.48% 4.04% 48.79%
TackShooter 1561 794 767 50.86% 8.93% 48.38%
WizardMonkey 1215 615 600 50.62% 6.95% 47.81%
BombShooter 656 338 318 51.52% 3.75% 47.70%
EngineerMonkey 293 154 139 52.56% 1.68% 46.84%
SpikeFactory 1009 498 511 49.36% 5.77% 46.27%
DartlingGunner 729 359 370 49.25% 4.17% 45.62%
GlueGunner 1175 560 615 47.66% 6.72% 44.80%
MonkeyVillage 1180 546 634 46.27% 6.75% 43.43%
MonkeyAce 159 80 79 50.31% 0.91% 42.54%
SniperMonkey 839 378 461 45.05% 4.80% 41.69%
SuperMonkey 692 311 381 44.94% 3.96% 41.24%
NinjaMonkey 747 332 415 44.44% 4.27% 40.88%
HeliPilot 562 239 323 42.53% 3.21% 38.44%
MonkeySub 182 81 101 44.51% 1.04% 37.29%
Alchemist 356 136 220 38.20% 2.04% 33.15%
Druid 276 104 172 37.68% 1.58% 31.96%
MonkeyBuccaneer 84 23 61 27.38% 0.48% 17.84%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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