pirate_cove_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 4562 2580 1982 56.55% 6.53% 55.12%
BananaFarm 16143 8703 7440 53.91% 23.09% 53.14%
TackShooter 16523 8900 7623 53.86% 23.63% 53.10%
BombShooter 1597 857 740 53.66% 2.28% 51.22%
WizardMonkey 9887 5150 4737 52.09% 14.14% 51.10%
IceMonkey 2104 1043 1061 49.57% 3.01% 47.44%
GlueGunner 2950 1400 1550 47.46% 4.22% 45.66%
EngineerMonkey 961 439 522 45.68% 1.37% 42.53%
MonkeyAce 677 304 373 44.90% 0.97% 41.16%
MonkeySub 1545 660 885 42.72% 2.21% 40.25%
Alchemist 680 295 385 43.38% 0.97% 39.66%
DartMonkey 962 402 560 41.79% 1.38% 38.67%
SniperMonkey 2428 980 1448 40.36% 3.47% 38.41%
NinjaMonkey 1636 653 983 39.91% 2.34% 37.54%
HeliPilot 857 337 520 39.32% 1.23% 36.05%
MonkeyVillage 1530 584 946 38.17% 2.19% 35.74%
BoomerangMonkey 1255 463 792 36.89% 1.80% 34.22%
MonkeyBuccaneer 676 237 439 35.06% 0.97% 31.46%
SuperMonkey 937 319 618 34.04% 1.34% 31.01%
Druid 540 183 357 33.89% 0.77% 29.90%
DartlingGunner 693 229 464 33.04% 0.99% 29.54%
SpikeFactory 769 238 531 30.95% 1.10% 27.68%

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;