garden_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Winrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 323 229 94 70.90% 2.81% 65.94%
BananaFarm 1394 767 627 55.02% 12.11% 52.41%
DartMonkey 1983 1040 943 52.45% 17.22% 50.25%
MonkeySub 364 201 163 55.22% 3.16% 50.11%
GlueGunner 990 496 494 50.10% 8.60% 46.99%
SniperMonkey 927 456 471 49.19% 8.05% 45.97%
EngineerMonkey 194 101 93 52.06% 1.68% 45.03%
BoomerangMonkey 313 158 155 50.48% 2.72% 44.94%
DartlingGunner 353 176 177 49.86% 3.07% 44.64%
Druid 321 157 164 48.91% 2.79% 43.44%
BombShooter 168 85 83 50.60% 1.46% 43.03%
SpikeFactory 574 266 308 46.34% 4.99% 42.26%
MonkeyVillage 840 378 462 45.00% 7.30% 41.64%
WizardMonkey 491 226 265 46.03% 4.26% 41.62%
IceMonkey 235 112 123 47.66% 2.04% 41.27%
SuperMonkey 410 189 221 46.10% 3.56% 41.27%
NinjaMonkey 594 264 330 44.44% 5.16% 40.45%
HeliPilot 151 73 78 48.34% 1.31% 40.37%
MonkeyBuccaneer 306 140 166 45.75% 2.66% 40.17%
Alchemist 270 120 150 44.44% 2.34% 38.52%
MonkeyAce 91 43 48 47.25% 0.79% 37.00%
TackShooter 222 80 142 36.04% 1.93% 29.72%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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