oasis_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 3676 2042 1634 55.55% 15.24% 53.94%
BombShooter 1589 874 715 55.00% 6.59% 52.56%
DartMonkey 1048 577 471 55.06% 4.34% 52.05%
EngineerMonkey 538 297 241 55.20% 2.23% 51.00%
IceMonkey 827 445 382 53.81% 3.43% 50.41%
MonkeyAce 357 197 160 55.18% 1.48% 50.02%
MonkeySub 1297 684 613 52.74% 5.38% 50.02%
MortarMonkey 334 177 157 52.99% 1.38% 47.64%
BoomerangMonkey 643 325 318 50.54% 2.67% 46.68%
DartlingGunner 1073 526 547 49.02% 4.45% 46.03%
SpikeFactory 1608 774 834 48.13% 6.67% 45.69%
WizardMonkey 1287 623 664 48.41% 5.33% 45.68%
MonkeyVillage 1562 752 810 48.14% 6.47% 45.67%
GlueGunner 1268 602 666 47.48% 5.26% 44.73%
Druid 857 411 446 47.96% 3.55% 44.61%
SuperMonkey 1142 540 602 47.29% 4.73% 44.39%
TackShooter 813 377 436 46.37% 3.37% 42.94%
NinjaMonkey 1094 492 602 44.97% 4.53% 42.02%
SniperMonkey 1111 497 614 44.73% 4.60% 41.81%
Alchemist 807 361 446 44.73% 3.34% 41.30%
HeliPilot 649 273 376 42.06% 2.69% 38.27%
MonkeyBuccaneer 546 217 329 39.74% 2.26% 35.64%

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;