star_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartlingGunner 1185 646 539 54.51% 5.04% 51.68%
BananaFarm 4176 2221 1955 53.18% 17.78% 51.67%
TackShooter 2027 1073 954 52.94% 8.63% 50.76%
WizardMonkey 1840 967 873 52.55% 7.83% 50.27%
IceMonkey 1819 941 878 51.73% 7.74% 49.44%
MonkeySub 1686 854 832 50.65% 7.18% 48.27%
BombShooter 605 315 290 52.07% 2.58% 48.09%
BoomerangMonkey 695 358 337 51.51% 2.96% 47.80%
MonkeyVillage 1640 815 825 49.70% 6.98% 47.28%
MonkeyAce 276 142 134 51.45% 1.17% 45.55%
EngineerMonkey 575 284 291 49.39% 2.45% 45.30%
NinjaMonkey 947 456 491 48.15% 4.03% 44.97%
GlueGunner 807 390 417 48.33% 3.44% 44.88%
MortarMonkey 140 74 66 52.86% 0.60% 44.59%
DartMonkey 262 131 131 50.00% 1.12% 43.95%
SuperMonkey 1101 485 616 44.05% 4.69% 41.12%
SpikeFactory 849 372 477 43.82% 3.61% 40.48%
Alchemist 348 158 190 45.40% 1.48% 40.17%
HeliPilot 611 268 343 43.86% 2.60% 39.93%
Druid 511 219 292 42.86% 2.18% 38.57%
SniperMonkey 1049 430 619 40.99% 4.47% 38.02%
MonkeyBuccaneer 341 146 195 42.82% 1.45% 37.56%

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;