star_loadouts (view)

47 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, IceMonkey, MonkeySub 1605 921 684 57.38% 19.81% 54.96%
BananaFarm, EngineerMonkey, MonkeyAce 112 70 42 62.50% 1.38% 53.53%
BananaFarm, BoomerangMonkey, EngineerMonkey 83 52 31 62.65% 1.02% 52.24%
BananaFarm, DartlingGunner, IceMonkey 230 133 97 57.83% 2.84% 51.44%
BananaFarm, NinjaMonkey, WizardMonkey 123 73 50 59.35% 1.52% 50.67%
DartlingGunner, IceMonkey, MonkeyVillage 48 30 18 62.50% 0.59% 48.80%
BananaFarm, Druid, MonkeySub 379 203 176 53.56% 4.68% 48.54%
BananaFarm, TackShooter, WizardMonkey 395 207 188 52.41% 4.88% 47.48%
BananaFarm, BoomerangMonkey, NinjaMonkey 98 56 42 57.14% 1.21% 47.34%
BananaFarm, BombShooter, MonkeySub 386 198 188 51.30% 4.77% 46.31%
BananaFarm, BombShooter, WizardMonkey 68 39 29 57.35% 0.84% 45.60%
BananaFarm, SniperMonkey, TackShooter 79 44 35 55.70% 0.98% 44.74%
BananaFarm, MonkeySub, TackShooter 114 61 53 53.51% 1.41% 44.35%
GlueGunner, MonkeyVillage, TackShooter 341 169 172 49.56% 4.21% 44.25%
DartMonkey, DartlingGunner, GlueGunner 31 19 12 61.29% 0.38% 44.14%
DartMonkey, GlueGunner, MonkeyVillage 28 17 11 60.71% 0.35% 42.62%
BananaFarm, GlueGunner, TackShooter 55 30 25 54.55% 0.68% 41.39%
DartlingGunner, MonkeyVillage, SuperMonkey 102 50 52 49.02% 1.26% 39.32%
BananaFarm, BoomerangMonkey, MonkeySub 45 24 21 53.33% 0.56% 38.76%
GlueGunner, HeliPilot, MonkeyVillage 39 21 18 53.85% 0.48% 38.20%
IceMonkey, MonkeyVillage, NinjaMonkey 39 21 18 53.85% 0.48% 38.20%
BananaFarm, BombShooter, SpikeFactory 76 37 39 48.68% 0.94% 37.45%
BananaFarm, MonkeySub, SuperMonkey 36 19 17 52.78% 0.44% 36.47%
MonkeyVillage, SniperMonkey, TackShooter 36 19 17 52.78% 0.44% 36.47%
BananaFarm, BoomerangMonkey, SpikeFactory 57 28 29 49.12% 0.70% 36.14%
EngineerMonkey, TackShooter, WizardMonkey 40 20 20 50.00% 0.49% 34.50%
BombShooter, MonkeyVillage, SpikeFactory 45 22 23 48.89% 0.56% 34.28%
EngineerMonkey, SniperMonkey, WizardMonkey 22 12 10 54.55% 0.27% 33.74%
BananaFarm, SniperMonkey, WizardMonkey 74 33 41 44.59% 0.91% 33.27%
SniperMonkey, TackShooter, WizardMonkey 54 25 29 46.30% 0.67% 33.00%
Alchemist, MonkeyBuccaneer, SpikeFactory 52 24 28 46.15% 0.64% 32.60%
BananaFarm, BoomerangMonkey, WizardMonkey 23 12 11 52.17% 0.28% 31.76%
BananaFarm, DartlingGunner, NinjaMonkey 23 12 11 52.17% 0.28% 31.76%
DartlingGunner, Druid, SpikeFactory 25 12 13 48.00% 0.31% 28.42%
NinjaMonkey, SniperMonkey, WizardMonkey 20 10 10 50.00% 0.25% 28.09%
SniperMonkey, SpikeFactory, TackShooter 20 10 10 50.00% 0.25% 28.09%
BananaFarm, DartlingGunner, SuperMonkey 74 29 45 39.19% 0.91% 28.07%
BananaFarm, BombShooter, DartlingGunner 31 14 17 45.16% 0.38% 27.64%
SpikeFactory, TackShooter, WizardMonkey 21 10 11 47.62% 0.26% 26.26%
BananaFarm, MortarMonkey, TackShooter 27 12 15 44.44% 0.33% 25.70%
BananaFarm, MonkeySub, WizardMonkey 30 13 17 43.33% 0.37% 25.60%
BananaFarm, MonkeySub, SpikeFactory 36 15 21 41.67% 0.44% 25.56%
Alchemist, BananaFarm, NinjaMonkey 40 16 24 40.00% 0.49% 24.82%
IceMonkey, MonkeyVillage, TackShooter 73 25 48 34.25% 0.90% 23.36%
BananaFarm, DartMonkey, IceMonkey 23 10 13 43.48% 0.28% 23.22%
HeliPilot, IceMonkey, MonkeyVillage 33 13 20 39.39% 0.41% 22.72%
SniperMonkey, SuperMonkey, TackShooter 33 12 21 36.36% 0.41% 19.95%

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;