precious_space_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BombShooter 6409 3694 2715 57.64% 6.21% 56.43%
MortarMonkey 1900 1111 789 58.47% 1.84% 56.26%
MonkeySub 10472 5974 4498 57.05% 10.14% 56.10%
BananaFarm 18698 10265 8433 54.90% 18.11% 54.19%
BoomerangMonkey 5201 2752 2449 52.91% 5.04% 51.56%
Druid 3709 1871 1838 50.44% 3.59% 48.84%
MonkeyAce 1098 555 543 50.55% 1.06% 47.59%
SpikeFactory 7265 3536 3729 48.67% 7.04% 47.52%
DartlingGunner 6501 3163 3338 48.65% 6.30% 47.44%
DartMonkey 2054 1002 1052 48.78% 1.99% 46.62%
MonkeyBuccaneer 2854 1349 1505 47.27% 2.76% 45.44%
Alchemist 3434 1606 1828 46.77% 3.33% 45.10%
TackShooter 3657 1657 2000 45.31% 3.54% 43.70%
IceMonkey 1897 870 1027 45.86% 1.84% 43.62%
SuperMonkey 3944 1778 2166 45.08% 3.82% 43.53%
WizardMonkey 5649 2523 3126 44.66% 5.47% 43.37%
MonkeyVillage 3209 1408 1801 43.88% 3.11% 42.16%
SniperMonkey 5748 2466 3282 42.90% 5.57% 41.62%
HeliPilot 1620 712 908 43.95% 1.57% 41.53%
GlueGunner 3339 1422 1917 42.59% 3.23% 40.91%
NinjaMonkey 3438 1431 2007 41.62% 3.33% 39.98%
EngineerMonkey 1140 473 667 41.49% 1.10% 38.63%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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