dino_graveyard_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
MonkeyAce 9280 5646 3634 60.84% 6.04% 59.85%
EngineerMonkey 8060 4899 3161 60.78% 5.25% 59.72%
BananaFarm 24204 13321 10883 55.04% 15.76% 54.41%
MonkeySub 8017 4284 3733 53.44% 5.22% 52.34%
Druid 5937 3037 2900 51.15% 3.87% 49.88%
BoomerangMonkey 5125 2559 2566 49.93% 3.34% 48.56%
DartMonkey 4268 2115 2153 49.55% 2.78% 48.05%
IceMonkey 4375 2162 2213 49.42% 2.85% 47.94%
MortarMonkey 1271 642 629 50.51% 0.83% 47.76%
WizardMonkey 8673 4165 4508 48.02% 5.65% 46.97%
SpikeFactory 9443 4506 4937 47.72% 6.15% 46.71%
BombShooter 2939 1396 1543 47.50% 1.91% 45.69%
MonkeyBuccaneer 3449 1630 1819 47.26% 2.25% 45.59%
DartlingGunner 8212 3824 4388 46.57% 5.35% 45.49%
MonkeyVillage 9181 4240 4941 46.18% 5.98% 45.16%
Alchemist 4825 2240 2585 46.42% 3.14% 45.02%
TackShooter 4467 2014 2453 45.09% 2.91% 43.63%
SniperMonkey 7843 3501 4342 44.64% 5.11% 43.54%
SuperMonkey 7757 3443 4314 44.39% 5.05% 43.28%
NinjaMonkey 6519 2892 3627 44.36% 4.25% 43.16%
GlueGunner 6144 2697 3447 43.90% 4.00% 42.66%
HeliPilot 3545 1554 1991 43.84% 2.31% 42.20%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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