garden_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MortarMonkey 2174 1389 785 63.89% 2.53% 61.87%
DartMonkey 12424 6715 5709 54.05% 14.43% 53.17%
BananaFarm 12704 6776 5928 53.34% 14.76% 52.47%
MonkeySub 3918 2062 1856 52.63% 4.55% 51.07%
BoomerangMonkey 3021 1580 1441 52.30% 3.51% 50.52%
SniperMonkey 6299 3113 3186 49.42% 7.32% 48.19%
GlueGunner 5884 2906 2978 49.39% 6.83% 48.11%
DartlingGunner 3277 1623 1654 49.53% 3.81% 47.82%
MonkeyAce 961 488 473 50.78% 1.12% 47.62%
Druid 1849 909 940 49.16% 2.15% 46.88%
NinjaMonkey 4638 2241 2397 48.32% 5.39% 46.88%
SpikeFactory 4099 1945 2154 47.45% 4.76% 45.92%
MonkeyVillage 4798 2257 2541 47.04% 5.57% 45.63%
EngineerMonkey 1694 801 893 47.28% 1.97% 44.91%
WizardMonkey 4441 2058 2383 46.34% 5.16% 44.87%
IceMonkey 2046 959 1087 46.87% 2.38% 44.71%
MonkeyBuccaneer 2033 937 1096 46.09% 2.36% 43.92%
Alchemist 2090 961 1129 45.98% 2.43% 43.84%
BombShooter 1189 546 643 45.92% 1.38% 43.09%
SuperMonkey 2986 1302 1684 43.60% 3.47% 41.82%
TackShooter 2313 968 1345 41.85% 2.69% 39.84%
HeliPilot 1256 511 745 40.68% 1.46% 37.97%

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;