oasis_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 769 449 320 58.39% 3.46% 54.90%
BombShooter 1241 701 540 56.49% 5.58% 53.73%
MonkeySub 1018 568 450 55.80% 4.58% 52.74%
BananaFarm 3115 1682 1433 54.00% 14.01% 52.25%
MortarMonkey 296 169 127 57.09% 1.33% 51.46%
DartMonkey 1193 626 567 52.47% 5.37% 49.64%
SpikeFactory 1512 776 736 51.32% 6.80% 48.80%
EngineerMonkey 497 261 236 52.52% 2.24% 48.12%
BoomerangMonkey 637 330 307 51.81% 2.86% 47.92%
MonkeyAce 274 146 128 53.28% 1.23% 47.38%
MonkeyVillage 1605 785 820 48.91% 7.22% 46.46%
Druid 900 447 453 49.67% 4.05% 46.40%
WizardMonkey 1252 594 658 47.44% 5.63% 44.68%
GlueGunner 1378 647 731 46.95% 6.20% 44.32%
SniperMonkey 1177 539 638 45.79% 5.29% 42.95%
DartlingGunner 770 356 414 46.23% 3.46% 42.71%
NinjaMonkey 1143 518 625 45.32% 5.14% 42.43%
TackShooter 732 330 402 45.08% 3.29% 41.48%
HeliPilot 438 202 236 46.12% 1.97% 41.45%
Alchemist 807 361 446 44.73% 3.63% 41.30%
SuperMonkey 962 415 547 43.14% 4.33% 40.01%
MonkeyBuccaneer 520 216 304 41.54% 2.34% 37.30%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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