splashdown_towers (view)

19 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 306 183 123 59.80% 14.66% 54.31%
WizardMonkey 210 122 88 58.10% 10.06% 51.42%
TackShooter 121 68 53 56.20% 5.80% 47.36%
BoomerangMonkey 85 48 37 56.47% 4.07% 45.93%
MonkeySub 167 85 82 50.90% 8.00% 43.32%
Druid 36 21 15 58.33% 1.72% 42.23%
Alchemist 189 91 98 48.15% 9.05% 41.02%
SpikeFactory 243 114 129 46.91% 11.64% 40.64%
MortarMonkey 33 18 15 54.55% 1.58% 37.56%
MonkeyBuccaneer 241 105 136 43.57% 11.54% 37.31%
EngineerMonkey 45 22 23 48.89% 2.16% 34.28%
HeliPilot 54 25 29 46.30% 2.59% 33.00%
SniperMonkey 43 20 23 46.51% 2.06% 31.60%
MonkeyAce 21 11 10 52.38% 1.01% 31.02%
IceMonkey 66 27 39 40.91% 3.16% 29.05%
SuperMonkey 47 20 27 42.55% 2.25% 28.42%
NinjaMonkey 43 18 25 41.86% 2.06% 27.11%
DartlingGunner 32 13 19 40.63% 1.53% 23.61%
BombShooter 27 11 16 40.74% 1.29% 22.21%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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