precious_space_loadouts (view)

32 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, MonkeySub, SpikeFactory 69 53 16 76.81% 1.75% 66.85%
BananaFarm, DartlingGunner, NinjaMonkey 84 61 23 72.62% 2.13% 63.08%
BananaFarm, BoomerangMonkey, MortarMonkey 80 57 23 71.25% 2.03% 61.33%
BananaFarm, BombShooter, MonkeySub 652 420 232 64.42% 16.52% 60.74%
BananaFarm, MonkeyAce, MonkeySub 48 33 15 68.75% 1.22% 55.64%
DartlingGunner, MonkeyVillage, SuperMonkey 93 56 37 60.22% 2.36% 50.27%
BananaFarm, GlueGunner, MonkeySub 29 19 10 65.52% 0.73% 48.22%
BananaFarm, Druid, MonkeySub 113 64 49 56.64% 2.86% 47.50%
BananaFarm, BoomerangMonkey, MonkeySub 57 34 23 59.65% 1.44% 46.91%
BananaFarm, BoomerangMonkey, SpikeFactory 98 53 45 54.08% 2.48% 44.22%
Alchemist, DartlingGunner, SpikeFactory 73 40 33 54.79% 1.85% 43.38%
BananaFarm, IceMonkey, MonkeySub 142 73 69 51.41% 3.60% 43.19%
BananaFarm, MonkeySub, TackShooter 38 21 17 55.26% 0.96% 39.45%
BananaFarm, SniperMonkey, WizardMonkey 60 31 29 51.67% 1.52% 39.02%
BananaFarm, BombShooter, WizardMonkey 28 16 12 57.14% 0.71% 38.81%
BananaFarm, DartlingGunner, SuperMonkey 45 23 22 51.11% 1.14% 36.51%
Alchemist, MonkeyBuccaneer, SpikeFactory 73 35 38 47.95% 1.85% 36.48%
BananaFarm, TackShooter, WizardMonkey 164 69 95 42.07% 4.16% 34.52%
MonkeyBuccaneer, SpikeFactory, WizardMonkey 25 13 12 52.00% 0.63% 32.42%
BananaFarm, DartlingGunner, IceMonkey 38 18 20 47.37% 0.96% 31.49%
BananaFarm, BoomerangMonkey, WizardMonkey 21 11 10 52.38% 0.53% 31.02%
MonkeySub, MonkeyVillage, TackShooter 26 13 13 50.00% 0.66% 30.78%
BananaFarm, DartlingGunner, GlueGunner 27 13 14 48.15% 0.68% 29.30%
Alchemist, BananaFarm, NinjaMonkey 22 11 11 50.00% 0.56% 29.11%
BananaFarm, DartlingGunner, SpikeFactory 39 17 22 43.59% 0.99% 28.03%
BananaFarm, NinjaMonkey, WizardMonkey 28 13 15 46.43% 0.71% 27.96%
SniperMonkey, TackShooter, WizardMonkey 31 14 17 45.16% 0.79% 27.64%
BananaFarm, BoomerangMonkey, SniperMonkey 34 15 19 44.12% 0.86% 27.43%
BananaFarm, BoomerangMonkey, NinjaMonkey 37 16 21 43.24% 0.94% 27.28%
BananaFarm, DartlingGunner, SniperMonkey 26 12 14 46.15% 0.66% 26.99%
BananaFarm, SniperMonkey, TackShooter 43 15 28 34.88% 1.09% 20.64%
BananaFarm, BombShooter, SpikeFactory 32 11 21 34.38% 0.81% 17.92%

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;