koru_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
IceMonkey 344 227 117 65.99% 3.03% 60.98%
BananaFarm 2140 1213 927 56.68% 18.82% 54.58%
DartlingGunner 339 193 146 56.93% 2.98% 51.66%
TackShooter 1729 931 798 53.85% 15.21% 51.50%
MortarMonkey 546 299 247 54.76% 4.80% 50.59%
WizardMonkey 1222 626 596 51.23% 10.75% 48.42%
MonkeyAce 158 85 73 53.80% 1.39% 46.02%
DartMonkey 268 133 135 49.63% 2.36% 43.64%
BoomerangMonkey 524 249 275 47.52% 4.61% 43.24%
GlueGunner 648 299 349 46.14% 5.70% 42.30%
SpikeFactory 583 265 318 45.45% 5.13% 41.41%
EngineerMonkey 158 74 84 46.84% 1.39% 39.05%
BombShooter 382 167 215 43.72% 3.36% 38.74%
SuperMonkey 306 134 172 43.79% 2.69% 38.23%
NinjaMonkey 363 155 208 42.70% 3.19% 37.61%
SniperMonkey 510 205 305 40.20% 4.49% 35.94%
MonkeyVillage 389 154 235 39.59% 3.42% 34.73%
Alchemist 166 66 100 39.76% 1.46% 32.31%
MonkeySub 184 72 112 39.13% 1.62% 32.08%
Druid 177 67 110 37.85% 1.56% 30.71%
HeliPilot 115 35 80 30.43% 1.01% 22.02%
MonkeyBuccaneer 119 36 83 30.25% 1.05% 22.00%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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