star_loadouts (view)

347 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BombShooter, DartMonkey 101 74 27 73.27% 0.16% 64.64%
BananaFarm, DartMonkey, MortarMonkey 412 269 143 65.29% 0.64% 60.69%
BananaFarm, DartMonkey, WizardMonkey 160 107 53 66.88% 0.25% 59.58%
BananaFarm, EngineerMonkey, MonkeyAce 959 596 363 62.15% 1.48% 59.08%
DartlingGunner, HeliPilot, MortarMonkey 51 36 15 70.59% 0.08% 58.08%
BananaFarm, DartlingGunner, IceMonkey 1446 869 577 60.10% 2.24% 57.57%
BananaFarm, DartMonkey, GlueGunner 668 399 269 59.73% 1.03% 56.01%
DartMonkey, DartlingGunner, GlueGunner 80 53 27 66.25% 0.12% 55.89%
BananaFarm, BoomerangMonkey, NinjaMonkey 647 382 265 59.04% 1.00% 55.25%
BananaFarm, BombShooter, MonkeySub 2290 1309 981 57.16% 3.54% 55.13%
BananaFarm, IceMonkey, MonkeySub 3898 2206 1692 56.59% 6.03% 55.04%
DartlingGunner, IceMonkey, MonkeyVillage 436 258 178 59.17% 0.67% 54.56%
HeliPilot, IceMonkey, SuperMonkey 473 277 196 58.56% 0.73% 54.12%
DartMonkey, IceMonkey, MonkeyVillage 396 232 164 58.59% 0.61% 53.73%
GlueGunner, MonkeyVillage, TackShooter 4143 2261 1882 54.57% 6.41% 53.06%
BananaFarm, TackShooter, WizardMonkey 3001 1640 1361 54.65% 4.64% 52.87%
BananaFarm, BoomerangMonkey, EngineerMonkey 245 144 101 58.78% 0.38% 52.61%
BananaFarm, BombShooter, WizardMonkey 879 491 388 55.86% 1.36% 52.58%
BananaFarm, DartlingGunner, NinjaMonkey 365 209 156 57.26% 0.56% 52.19%
BoomerangMonkey, GlueGunner, MonkeySub 59 38 21 64.41% 0.09% 52.19%
BananaFarm, IceMonkey, MonkeyBuccaneer 542 305 237 56.27% 0.84% 52.10%
DartlingGunner, MonkeyVillage, NinjaMonkey 49 32 17 65.31% 0.08% 51.98%
IceMonkey, SniperMonkey, TackShooter 34 23 11 67.65% 0.05% 51.92%
BananaFarm, DartMonkey, NinjaMonkey 51 33 18 64.71% 0.08% 51.59%
GlueGunner, MonkeySub, MonkeyVillage 100 61 39 61.00% 0.15% 51.44%
BananaFarm, BoomerangMonkey, MortarMonkey 223 129 94 57.85% 0.35% 51.37%
BananaFarm, MonkeyAce, MonkeySub 31 21 10 67.74% 0.05% 51.29%
DartMonkey, GlueGunner, MonkeyVillage 631 348 283 55.15% 0.98% 51.27%
BananaFarm, HeliPilot, IceMonkey 167 98 69 58.68% 0.26% 51.21%
Alchemist, MonkeyBuccaneer, SpikeFactory 736 403 333 54.76% 1.14% 51.16%
BombShooter, MonkeySub, SpikeFactory 133 79 54 59.40% 0.21% 51.05%
BananaFarm, DartMonkey, MonkeySub 117 70 47 59.83% 0.18% 50.95%
BananaFarm, EngineerMonkey, MonkeySub 69 43 26 62.32% 0.11% 50.88%
IceMonkey, MonkeyVillage, NinjaMonkey 246 140 106 56.91% 0.38% 50.72%
MonkeySub, SpikeFactory, TackShooter 131 77 54 58.78% 0.20% 50.35%
DartlingGunner, Druid, SpikeFactory 181 104 77 57.46% 0.28% 50.26%
BananaFarm, BombShooter, DartlingGunner 222 126 96 56.76% 0.34% 50.24%
BananaFarm, Druid, MonkeySub 2334 1219 1115 52.23% 3.61% 50.20%
BananaFarm, NinjaMonkey, WizardMonkey 371 205 166 55.26% 0.57% 50.20%
IceMonkey, MonkeyBuccaneer, SuperMonkey 117 69 48 58.97% 0.18% 50.06%
BoomerangMonkey, IceMonkey, MonkeySub 56 35 21 62.50% 0.09% 49.82%
BoomerangMonkey, MonkeySub, SpikeFactory 112 66 46 58.93% 0.17% 49.82%
BananaFarm, EngineerMonkey, WizardMonkey 129 75 54 58.14% 0.20% 49.63%
BananaFarm, IceMonkey, SuperMonkey 297 164 133 55.22% 0.46% 49.56%
DartlingGunner, MonkeyVillage, SuperMonkey 1378 714 664 51.81% 2.13% 49.18%
BananaFarm, BoomerangMonkey, SniperMonkey 252 139 113 55.16% 0.39% 49.02%
BananaFarm, BoomerangMonkey, MonkeySub 237 131 106 55.27% 0.37% 48.94%
MonkeyAce, SniperMonkey, WizardMonkey 112 65 47 58.04% 0.17% 48.90%
GlueGunner, MonkeyBuccaneer, MonkeyVillage 83 49 34 59.04% 0.13% 48.46%
BananaFarm, MonkeySub, TackShooter 496 262 234 52.82% 0.77% 48.43%

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;