salmon_pool_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 245 153 92 62.45% 2.04% 56.39%
BananaFarm 1488 803 685 53.97% 12.41% 51.43%
MortarMonkey 162 95 67 58.64% 1.35% 51.06%
BombShooter 382 212 170 55.50% 3.18% 50.51%
SpikeFactory 1573 821 752 52.19% 13.11% 49.72%
Alchemist 1022 539 483 52.74% 8.52% 49.68%
EngineerMonkey 231 128 103 55.41% 1.93% 49.00%
MonkeyBuccaneer 1470 754 716 51.29% 12.26% 48.74%
DartMonkey 716 371 345 51.82% 5.97% 48.16%
MonkeySub 711 360 351 50.63% 5.93% 46.96%
DartlingGunner 414 207 207 50.00% 3.45% 45.18%
BoomerangMonkey 268 133 135 49.63% 2.23% 43.64%
MonkeyVillage 303 147 156 48.51% 2.53% 42.89%
SuperMonkey 382 179 203 46.86% 3.18% 41.85%
WizardMonkey 551 238 313 43.19% 4.59% 39.06%
GlueGunner 418 182 236 43.54% 3.49% 38.79%
SniperMonkey 540 229 311 42.41% 4.50% 38.24%
Druid 232 101 131 43.53% 1.93% 37.15%
NinjaMonkey 273 109 164 39.93% 2.28% 34.12%
TackShooter 257 102 155 39.69% 2.14% 33.71%
HeliPilot 191 75 116 39.27% 1.59% 32.34%
IceMonkey 165 59 106 35.76% 1.38% 28.44%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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