splashdown_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 232 140 92 60.34% 1.76% 54.05%
BananaFarm 1858 1038 820 55.87% 14.11% 53.61%
BoomerangMonkey 509 291 218 57.17% 3.87% 52.87%
WizardMonkey 1068 586 482 54.87% 8.11% 51.88%
Druid 191 110 81 57.59% 1.45% 50.58%
EngineerMonkey 371 203 168 54.72% 2.82% 49.65%
BombShooter 198 108 90 54.55% 1.50% 47.61%
Alchemist 844 420 424 49.76% 6.41% 46.39%
SpikeFactory 1156 568 588 49.13% 8.78% 46.25%
MonkeySub 1421 692 729 48.70% 10.79% 46.10%
TackShooter 628 311 317 49.52% 4.77% 45.61%
MonkeyBuccaneer 1272 602 670 47.33% 9.66% 44.58%
IceMonkey 800 376 424 47.00% 6.08% 43.54%
HeliPilot 415 195 220 46.99% 3.15% 42.19%
DartMonkey 174 84 90 48.28% 1.32% 40.85%
MonkeyAce 212 100 112 47.17% 1.61% 40.45%
NinjaMonkey 344 156 188 45.35% 2.61% 40.09%
MonkeyVillage 369 166 203 44.99% 2.80% 39.91%
DartlingGunner 154 68 86 44.16% 1.17% 36.31%
SniperMonkey 420 171 249 40.71% 3.19% 36.02%
SuperMonkey 265 103 162 38.87% 2.01% 33.00%
GlueGunner 263 94 169 35.74% 2.00% 29.95%

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;