up_on_the_roof_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyVillage 12105 6673 5432 55.13% 12.59% 54.24%
IceMonkey 3215 1789 1426 55.65% 3.34% 53.93%
MortarMonkey 1314 723 591 55.02% 1.37% 52.33%
DartMonkey 4376 2329 2047 53.22% 4.55% 51.74%
GlueGunner 6600 3449 3151 52.26% 6.87% 51.05%
HeliPilot 3170 1655 1515 52.21% 3.30% 50.47%
SuperMonkey 9252 4715 4537 50.96% 9.63% 49.94%
Alchemist 3197 1628 1569 50.92% 3.33% 49.19%
DartlingGunner 4651 2340 2311 50.31% 4.84% 48.87%
TackShooter 5696 2819 2877 49.49% 5.93% 48.19%
SpikeFactory 5767 2849 2918 49.40% 6.00% 48.11%
BoomerangMonkey 3125 1545 1580 49.44% 3.25% 47.69%
BombShooter 2042 1014 1028 49.66% 2.12% 47.49%
NinjaMonkey 4990 2389 2601 47.88% 5.19% 46.49%
BananaFarm 7390 3478 3912 47.06% 7.69% 45.93%
MonkeyAce 1002 481 521 48.00% 1.04% 44.91%
SniperMonkey 6668 3050 3618 45.74% 6.94% 44.55%
WizardMonkey 5956 2680 3276 45.00% 6.20% 43.73%
EngineerMonkey 1473 672 801 45.62% 1.53% 43.08%
MonkeySub 1162 527 635 45.35% 1.21% 42.49%
Druid 2146 942 1204 43.90% 2.23% 41.80%
MonkeyBuccaneer 817 310 507 37.94% 0.85% 34.62%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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