pirate_cove_towers (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
WizardMonkey 2094 1136 958 54.25% 20.66% 52.12%
TackShooter 2520 1356 1164 53.81% 24.87% 51.86%
BananaFarm 2499 1326 1173 53.06% 24.66% 51.10%
MortarMonkey 434 237 197 54.61% 4.28% 49.92%
Alchemist 83 44 39 53.01% 0.82% 42.27%
BombShooter 185 91 94 49.19% 1.83% 41.99%
BoomerangMonkey 161 70 91 43.48% 1.59% 35.82%
NinjaMonkey 193 82 111 42.49% 1.90% 35.51%
SniperMonkey 312 127 185 40.71% 3.08% 35.25%
EngineerMonkey 134 57 77 42.54% 1.32% 34.17%
HeliPilot 142 60 82 42.25% 1.40% 34.13%
IceMonkey 214 86 128 40.19% 2.11% 33.62%
SuperMonkey 137 55 82 40.15% 1.35% 31.94%
MonkeySub 147 55 92 37.41% 1.45% 29.59%
DartMonkey 58 24 34 41.38% 0.57% 28.70%
DartlingGunner 130 46 84 35.38% 1.28% 27.16%
MonkeyVillage 197 66 131 33.50% 1.94% 26.91%
GlueGunner 179 59 120 32.96% 1.77% 26.07%
MonkeyAce 85 28 57 32.94% 0.84% 22.95%
MonkeyBuccaneer 95 27 68 28.42% 0.94% 19.35%
SpikeFactory 88 25 63 28.41% 0.87% 18.99%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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