star_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 1193 667 526 55.91% 5.56% 53.09%
BananaFarm 3062 1639 1423 53.53% 14.28% 51.76%
MonkeySub 1063 561 502 52.78% 4.96% 49.77%
BoomerangMonkey 627 333 294 53.11% 2.92% 49.20%
BombShooter 799 413 386 51.69% 3.73% 48.22%
TackShooter 1618 816 802 50.43% 7.55% 48.00%
GlueGunner 1383 692 691 50.04% 6.45% 47.40%
DartMonkey 557 285 272 51.17% 2.60% 47.02%
DartlingGunner 1043 522 521 50.05% 4.86% 47.01%
MonkeyVillage 1840 894 946 48.59% 8.58% 46.30%
SpikeFactory 829 407 422 49.10% 3.87% 45.69%
Druid 588 290 298 49.32% 2.74% 45.28%
MonkeyBuccaneer 499 247 252 49.50% 2.33% 45.11%
MortarMonkey 279 142 137 50.90% 1.30% 45.03%
SuperMonkey 1258 595 663 47.30% 5.87% 44.54%
WizardMonkey 1141 537 604 47.06% 5.32% 44.17%
HeliPilot 704 332 372 47.16% 3.28% 43.47%
EngineerMonkey 398 190 208 47.74% 1.86% 42.83%
Alchemist 468 221 247 47.22% 2.18% 42.70%
NinjaMonkey 833 381 452 45.74% 3.88% 42.36%
SniperMonkey 1007 441 566 43.79% 4.70% 40.73%
MonkeyAce 255 117 138 45.88% 1.19% 39.77%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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