star_loadouts (view)

53 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce 231 152 79 65.80% 2.72% 59.68%
HeliPilot, IceMonkey, SuperMonkey 98 64 34 65.31% 1.15% 55.88%
BananaFarm, DartMonkey, GlueGunner 47 31 16 65.96% 0.55% 52.41%
DartMonkey, GlueGunner, MonkeyVillage 53 34 19 64.15% 0.62% 51.24%
BananaFarm, SniperMonkey, TackShooter 38 25 13 65.79% 0.45% 50.71%
BananaFarm, BombShooter, MonkeySub 737 400 337 54.27% 8.67% 50.68%
IceMonkey, MonkeyVillage, NinjaMonkey 71 44 27 61.97% 0.84% 50.68%
BananaFarm, IceMonkey, MonkeyBuccaneer 61 38 23 62.30% 0.72% 50.13%
BananaFarm, DartlingGunner, IceMonkey 265 148 117 55.85% 3.12% 49.87%
BananaFarm, IceMonkey, SuperMonkey 78 47 31 60.26% 0.92% 49.40%
GlueGunner, MonkeyVillage, TackShooter 578 307 271 53.11% 6.80% 49.05%
BananaFarm, TackShooter, WizardMonkey 471 250 221 53.08% 5.54% 48.57%
BananaFarm, GlueGunner, TackShooter 47 29 18 61.70% 0.55% 47.80%
BananaFarm, DartMonkey, MortarMonkey 31 20 11 64.52% 0.36% 47.67%
BananaFarm, BoomerangMonkey, EngineerMonkey 80 46 34 57.50% 0.94% 46.67%
BananaFarm, MonkeySub, TackShooter 65 38 27 58.46% 0.76% 46.48%
BombShooter, MonkeyVillage, SpikeFactory 50 30 20 60.00% 0.59% 46.42%
BananaFarm, Druid, MonkeySub 461 235 226 50.98% 5.42% 46.41%
BananaFarm, NinjaMonkey, WizardMonkey 47 28 19 59.57% 0.55% 45.54%
BananaFarm, BoomerangMonkey, NinjaMonkey 184 97 87 52.72% 2.16% 45.50%
BananaFarm, BombShooter, WizardMonkey 183 96 87 52.46% 2.15% 45.22%
Alchemist, MonkeyBuccaneer, SpikeFactory 63 36 27 57.14% 0.74% 44.92%
IceMonkey, MonkeyVillage, TackShooter 108 56 52 51.85% 1.27% 42.43%
BananaFarm, NinjaMonkey, TackShooter 32 19 13 59.38% 0.38% 42.36%
BananaFarm, MortarMonkey, TackShooter 36 21 15 58.33% 0.42% 42.23%
DartlingGunner, MonkeyVillage, SuperMonkey 188 90 98 47.87% 2.21% 40.73%
DartMonkey, IceMonkey, MonkeyVillage 42 23 19 54.76% 0.49% 39.71%
DartlingGunner, IceMonkey, MonkeyVillage 47 25 22 53.19% 0.55% 38.93%
SniperMonkey, SpikeFactory, WizardMonkey 30 17 13 56.67% 0.35% 38.93%
BananaFarm, BoomerangMonkey, SpikeFactory 103 50 53 48.54% 1.21% 38.89%
BananaFarm, BombShooter, SpikeFactory 110 53 57 48.18% 1.29% 38.84%
BananaFarm, BoomerangMonkey, MonkeySub 26 15 11 57.69% 0.31% 38.70%
BananaFarm, BoomerangMonkey, MortarMonkey 26 15 11 57.69% 0.31% 38.70%
BananaFarm, MonkeySub, SuperMonkey 81 39 42 48.15% 0.95% 37.27%
Alchemist, BananaFarm, NinjaMonkey 87 41 46 47.13% 1.02% 36.64%
SniperMonkey, TackShooter, WizardMonkey 43 22 21 51.16% 0.51% 36.22%
GlueGunner, HeliPilot, MonkeyVillage 148 64 84 43.24% 1.74% 35.26%
SpikeFactory, TackShooter, WizardMonkey 26 14 12 53.85% 0.31% 34.68%
BananaFarm, DartMonkey, WizardMonkey 24 13 11 54.17% 0.28% 34.23%
EngineerMonkey, TackShooter, WizardMonkey 36 18 18 50.00% 0.42% 33.67%
BananaFarm, BombShooter, MortarMonkey 29 15 14 51.72% 0.34% 33.54%
Alchemist, HeliPilot, NinjaMonkey 54 25 29 46.30% 0.64% 33.00%
IceMonkey, MonkeyVillage, SuperMonkey 23 12 11 52.17% 0.27% 31.76%
BananaFarm, GlueGunner, MonkeySub 38 18 20 47.37% 0.45% 31.49%
Druid, SniperMonkey, SuperMonkey 24 12 12 50.00% 0.28% 30.00%
BananaFarm, DartlingGunner, SuperMonkey 90 36 54 40.00% 1.06% 29.88%
BananaFarm, DartMonkey, MonkeySub 20 10 10 50.00% 0.24% 28.09%
BananaFarm, DartlingGunner, NinjaMonkey 29 13 16 44.83% 0.34% 26.73%
BananaFarm, IceMonkey, WizardMonkey 50 20 30 40.00% 0.59% 26.42%
Alchemist, DartlingGunner, SpikeFactory 23 10 13 43.48% 0.27% 23.22%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW star_loadouts AS 
WITH star AS
    (SELECT *
    FROM matches
    WHERE map = 'star')
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 star) * 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 star
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM star)
            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;