precious_space_loadouts (view)

26 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, BombShooter, MonkeySub 734 476 258 64.85% 15.99% 61.40%
BananaFarm, BoomerangMonkey, MortarMonkey 80 56 24 70.00% 1.74% 59.96%
BoomerangMonkey, IceMonkey, MonkeySub 34 24 10 70.59% 0.74% 55.27%
BananaFarm, MonkeyAce, MonkeySub 73 47 26 64.38% 1.59% 53.40%
BananaFarm, MonkeySub, SuperMonkey 37 24 13 64.86% 0.81% 49.48%
BananaFarm, Druid, MonkeySub 417 222 195 53.24% 9.08% 48.45%
BananaFarm, BombShooter, SniperMonkey 33 20 13 60.61% 0.72% 43.93%
Alchemist, DartlingGunner, SpikeFactory 115 61 54 53.04% 2.51% 43.92%
BananaFarm, BoomerangMonkey, SpikeFactory 148 75 73 50.68% 3.22% 42.62%
BananaFarm, BombShooter, WizardMonkey 43 24 19 55.81% 0.94% 40.97%
Alchemist, MonkeyBuccaneer, SpikeFactory 99 49 50 49.49% 2.16% 39.65%
BananaFarm, SniperMonkey, WizardMonkey 55 29 26 52.73% 1.20% 39.53%
BananaFarm, TackShooter, WizardMonkey 116 54 62 46.55% 2.53% 37.47%
BananaFarm, BoomerangMonkey, MonkeySub 58 29 29 50.00% 1.26% 37.13%
BananaFarm, BoomerangMonkey, NinjaMonkey 57 27 30 47.37% 1.24% 34.41%
BananaFarm, DartlingGunner, NinjaMonkey 45 22 23 48.89% 0.98% 34.28%
BananaFarm, DartMonkey, MortarMonkey 24 13 11 54.17% 0.52% 34.23%
DartMonkey, GlueGunner, MonkeyVillage 22 12 10 54.55% 0.48% 33.74%
BananaFarm, GlueGunner, MonkeySub 44 21 23 47.73% 0.96% 32.97%
BananaFarm, BombShooter, SpikeFactory 30 15 15 50.00% 0.65% 32.11%
Druid, MonkeySub, SpikeFactory 41 19 22 46.34% 0.89% 31.08%
DartlingGunner, MonkeyVillage, SuperMonkey 69 29 40 42.03% 1.50% 30.38%
BananaFarm, BoomerangMonkey, SniperMonkey 20 10 10 50.00% 0.44% 28.09%
BananaFarm, DartlingGunner, SuperMonkey 88 33 55 37.50% 1.92% 27.38%
BananaFarm, DartlingGunner, SpikeFactory 29 12 17 41.38% 0.63% 23.45%
BananaFarm, BoomerangMonkey, WizardMonkey 30 11 19 36.67% 0.65% 19.42%

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;