precious_space_loadouts (view)

27 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey 102 74 28 72.55% 2.19% 63.89%
BananaFarm, BombShooter, MonkeySub 365 230 135 63.01% 7.85% 58.06%
DartlingGunner, MonkeyVillage, SuperMonkey 149 94 55 63.09% 3.21% 55.34%
BananaFarm, Druid, MonkeySub 353 208 145 58.92% 7.59% 53.79%
BananaFarm, DartMonkey, MortarMonkey 87 55 32 63.22% 1.87% 53.09%
BananaFarm, DartlingGunner, SpikeFactory 36 24 12 66.67% 0.77% 51.27%
BananaFarm, BombShooter, WizardMonkey 65 39 26 60.00% 1.40% 48.09%
BananaFarm, BoomerangMonkey, SpikeFactory 107 59 48 55.14% 2.30% 45.72%
Alchemist, MonkeyBuccaneer, SpikeFactory 188 97 91 51.60% 4.04% 44.45%
BananaFarm, MonkeySub, SuperMonkey 35 21 14 60.00% 0.75% 43.77%
BananaFarm, BoomerangMonkey, MonkeySub 39 21 18 53.85% 0.84% 38.20%
BananaFarm, SniperMonkey, TackShooter 57 29 28 50.88% 1.23% 37.90%
Alchemist, DartlingGunner, SpikeFactory 126 57 69 45.24% 2.71% 36.55%
BananaFarm, DartlingGunner, SuperMonkey 87 40 47 45.98% 1.87% 35.50%
BananaFarm, DartlingGunner, NinjaMonkey 47 23 24 48.94% 1.01% 34.64%
Alchemist, BananaFarm, DartlingGunner 29 15 14 51.72% 0.62% 33.54%
BananaFarm, TackShooter, WizardMonkey 75 33 42 44.00% 1.61% 32.77%
BananaFarm, DartMonkey, WizardMonkey 23 12 11 52.17% 0.49% 31.76%
Druid, MonkeySub, SpikeFactory 43 20 23 46.51% 0.93% 31.60%
BananaFarm, BombShooter, SpikeFactory 63 27 36 42.86% 1.36% 30.64%
BananaFarm, DartMonkey, SpikeFactory 35 16 19 45.71% 0.75% 29.21%
MonkeyBuccaneer, SniperMonkey, TackShooter 20 10 10 50.00% 0.43% 28.09%
DartlingGunner, SpikeFactory, SuperMonkey 29 13 16 44.83% 0.62% 26.73%
BananaFarm, BoomerangMonkey, SniperMonkey 24 11 13 45.83% 0.52% 25.90%
BananaFarm, SniperMonkey, WizardMonkey 34 13 21 38.24% 0.73% 21.90%
Alchemist, GlueGunner, NinjaMonkey 42 15 27 35.71% 0.90% 21.22%
GlueGunner, HeliPilot, MonkeyVillage 40 13 27 32.50% 0.86% 17.98%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW precious_space_loadouts AS 
WITH precious_space AS
    (SELECT *
    FROM matches
    WHERE map = 'precious_space')
SELECT Loadout,
       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 Loadout,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM precious_space) * 2)    AS PR
      FROM (SELECT Loadout,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT printf('%s, %s, %s', lt1, lt2, lt3) AS Loadout,
                         playerLeftWin                       AS Win
                  FROM precious_space
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM precious_space)
            GROUP BY Loadout)
      WHERE Wins >= 10
        AND Losses >= 10)
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(WinRate_LowerBound_95CI) = 6
ORDER BY WinRate_LowerBound_95CI DESC;