inflection_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
DartMonkey 8120 4544 3576 55.96% 12.50% 54.88%
SpikeFactory 10862 5965 4897 54.92% 16.73% 53.98%
BananaFarm 12887 7018 5869 54.46% 19.85% 53.60%
MortarMonkey 1167 641 526 54.93% 1.80% 52.07%
DartlingGunner 4191 2208 1983 52.68% 6.45% 51.17%
BoomerangMonkey 2770 1399 1371 50.51% 4.27% 48.64%
MonkeySub 2713 1312 1401 48.36% 4.18% 46.48%
SuperMonkey 1352 652 700 48.22% 2.08% 45.56%
Alchemist 2429 1123 1306 46.23% 3.74% 44.25%
EngineerMonkey 751 354 397 47.14% 1.16% 43.57%
IceMonkey 1149 521 628 45.34% 1.77% 42.47%
NinjaMonkey 1827 800 1027 43.79% 2.81% 41.51%
SniperMonkey 2642 1114 1528 42.17% 4.07% 40.28%
MonkeyBuccaneer 1478 621 857 42.02% 2.28% 39.50%
WizardMonkey 2942 1182 1760 40.18% 4.53% 38.41%
GlueGunner 1894 763 1131 40.29% 2.92% 38.08%
MonkeyVillage 1446 583 863 40.32% 2.23% 37.79%
HeliPilot 672 277 395 41.22% 1.03% 37.50%
Druid 856 345 511 40.30% 1.32% 37.02%
TackShooter 1875 730 1145 38.93% 2.89% 36.73%
MonkeyAce 352 129 223 36.65% 0.54% 31.61%
BombShooter 563 188 375 33.39% 0.87% 29.50%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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