koru_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 19386 10651 8735 54.94% 21.51% 54.24%
TackShooter 15650 8386 7264 53.58% 17.36% 52.80%
WizardMonkey 13125 7029 6096 53.55% 14.56% 52.70%
MonkeyAce 1015 553 462 54.48% 1.13% 51.42%
IceMonkey 2717 1436 1281 52.85% 3.01% 50.98%
MortarMonkey 3070 1586 1484 51.66% 3.41% 49.89%
DartlingGunner 2119 1091 1028 51.49% 2.35% 49.36%
BoomerangMonkey 4037 1969 2068 48.77% 4.48% 47.23%
BombShooter 2241 1098 1143 49.00% 2.49% 46.93%
EngineerMonkey 1228 580 648 47.23% 1.36% 44.44%
SpikeFactory 3860 1738 2122 45.03% 4.28% 43.46%
DartMonkey 1489 673 816 45.20% 1.65% 42.67%
MonkeySub 1732 756 976 43.65% 1.92% 41.31%
GlueGunner 3667 1568 2099 42.76% 4.07% 41.16%
NinjaMonkey 2909 1232 1677 42.35% 3.23% 40.56%
MonkeyVillage 2495 1028 1467 41.20% 2.77% 39.27%
SuperMonkey 1856 767 1089 41.33% 2.06% 39.09%
SniperMonkey 3661 1478 2183 40.37% 4.06% 38.78%
Druid 1304 518 786 39.72% 1.45% 37.07%
Alchemist 1092 408 684 37.36% 1.21% 34.49%
HeliPilot 849 306 543 36.04% 0.94% 32.81%
MonkeyBuccaneer 642 221 421 34.42% 0.71% 30.75%

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;