star_loadouts (view)

56 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, DartlingGunner, IceMonkey 209 136 73 65.07% 2.92% 58.61%
BananaFarm, BoomerangMonkey, NinjaMonkey 58 40 18 68.97% 0.81% 57.06%
BananaFarm, IceMonkey, SuperMonkey 98 62 36 63.27% 1.37% 53.72%
Alchemist, MonkeyBuccaneer, SpikeFactory 87 55 32 63.22% 1.22% 53.09%
BananaFarm, DartMonkey, GlueGunner 81 51 30 62.96% 1.13% 52.45%
DartlingGunner, IceMonkey, MonkeyVillage 61 39 22 63.93% 0.85% 51.88%
BananaFarm, Druid, MonkeySub 296 170 126 57.43% 4.14% 51.80%
HeliPilot, IceMonkey, SuperMonkey 143 85 58 59.44% 2.00% 51.39%
GlueGunner, MonkeyVillage, TackShooter 507 280 227 55.23% 7.09% 50.90%
BananaFarm, BombShooter, MonkeySub 316 172 144 54.43% 4.42% 48.94%
DartlingGunner, MonkeyVillage, SuperMonkey 211 114 97 54.03% 2.95% 47.30%
BananaFarm, BombShooter, SpikeFactory 60 35 25 58.33% 0.84% 45.86%
BananaFarm, SniperMonkey, TackShooter 47 28 19 59.57% 0.66% 45.54%
BananaFarm, TackShooter, WizardMonkey 231 119 112 51.52% 3.23% 45.07%
BananaFarm, BombShooter, WizardMonkey 103 56 47 54.37% 1.44% 44.75%
BananaFarm, BoomerangMonkey, EngineerMonkey 42 25 17 59.52% 0.59% 44.68%
BananaFarm, DartMonkey, MortarMonkey 54 31 23 57.41% 0.76% 44.22%
BananaFarm, IceMonkey, MonkeyBuccaneer 63 35 28 55.56% 0.88% 43.29%
DartMonkey, GlueGunner, MonkeyVillage 98 52 46 53.06% 1.37% 43.18%
IceMonkey, MonkeyVillage, TackShooter 105 55 50 52.38% 1.47% 42.83%
SpikeFactory, TackShooter, WizardMonkey 28 17 11 60.71% 0.39% 42.62%
BananaFarm, BoomerangMonkey, SpikeFactory 30 18 12 60.00% 0.42% 42.47%
BananaFarm, MonkeySub, SuperMonkey 50 28 22 56.00% 0.70% 42.24%
BananaFarm, EngineerMonkey, MonkeyAce 167 83 84 49.70% 2.34% 42.12%
Druid, MonkeySub, SpikeFactory 39 22 17 56.41% 0.55% 40.85%
BananaFarm, IceMonkey, WizardMonkey 31 18 13 58.06% 0.43% 40.69%
Alchemist, BananaFarm, NinjaMonkey 47 24 23 51.06% 0.66% 36.77%
BananaFarm, SniperMonkey, WizardMonkey 68 33 35 48.53% 0.95% 36.65%
EngineerMonkey, TackShooter, WizardMonkey 23 13 10 56.52% 0.32% 36.26%
BananaFarm, GlueGunner, TackShooter 41 21 20 51.22% 0.57% 35.92%
Alchemist, HeliPilot, NinjaMonkey 58 28 30 48.28% 0.81% 35.42%
BananaFarm, BoomerangMonkey, MortarMonkey 26 14 12 53.85% 0.36% 34.68%
BananaFarm, BoomerangMonkey, SuperMonkey 26 14 12 53.85% 0.36% 34.68%
BananaFarm, DartlingGunner, SuperMonkey 133 57 76 42.86% 1.86% 34.45%
BananaFarm, IceMonkey, TackShooter 31 16 15 51.61% 0.43% 34.02%
GlueGunner, HeliPilot, MonkeyVillage 152 63 89 41.45% 2.13% 33.62%
DartMonkey, IceMonkey, MonkeyVillage 35 17 18 48.57% 0.49% 32.01%
BananaFarm, BoomerangMonkey, WizardMonkey 23 12 11 52.17% 0.32% 31.76%
BananaFarm, DartMonkey, WizardMonkey 23 12 11 52.17% 0.32% 31.76%
SniperMonkey, SpikeFactory, WizardMonkey 23 12 11 52.17% 0.32% 31.76%
IceMonkey, MonkeyVillage, SuperMonkey 34 16 18 47.06% 0.48% 30.28%
DartMonkey, MonkeyBuccaneer, TackShooter 22 11 11 50.00% 0.31% 29.11%
GlueGunner, MonkeyVillage, NinjaMonkey 38 17 21 44.74% 0.53% 28.93%
NinjaMonkey, SniperMonkey, WizardMonkey 30 14 16 46.67% 0.42% 28.81%
Alchemist, IceMonkey, NinjaMonkey 20 10 10 50.00% 0.28% 28.09%
GlueGunner, SniperMonkey, TackShooter 20 10 10 50.00% 0.28% 28.09%
BananaFarm, MonkeySub, TackShooter 42 18 24 42.86% 0.59% 27.89%
MonkeyVillage, SniperMonkey, TackShooter 34 15 19 44.12% 0.48% 27.43%
Alchemist, Druid, MonkeyVillage 24 11 13 45.83% 0.34% 25.90%
SniperMonkey, TackShooter, WizardMonkey 30 13 17 43.33% 0.42% 25.60%

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;