salmon_pool_loadouts (view)

174 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BombShooter, MortarMonkey 118 93 25 78.81% 0.42% 71.44%
Alchemist, DartMonkey, SpikeFactory 108 80 28 74.07% 0.39% 65.81%
BananaFarm, MonkeyAce, MonkeySub 387 266 121 68.73% 1.39% 64.12%
DartlingGunner, MonkeyVillage, SuperMonkey 311 215 96 69.13% 1.11% 64.00%
BananaFarm, DartMonkey, SpikeFactory 860 541 319 62.91% 3.08% 59.68%
BananaFarm, EngineerMonkey, MonkeyAce 413 264 149 63.92% 1.48% 59.29%
Alchemist, MonkeyBuccaneer, SpikeFactory 5368 3037 2331 56.58% 19.23% 55.25%
BananaFarm, BombShooter, WizardMonkey 178 111 67 62.36% 0.64% 55.24%
BananaFarm, BombShooter, MonkeySub 2133 1207 926 56.59% 7.64% 54.48%
BananaFarm, Druid, MonkeySub 678 383 295 56.49% 2.43% 52.76%
DartMonkey, GlueGunner, MonkeySub 131 80 51 61.07% 0.47% 52.72%
DartlingGunner, Druid, SpikeFactory 128 78 50 60.94% 0.46% 52.49%
BananaFarm, DartlingGunner, NinjaMonkey 135 81 54 60.00% 0.48% 51.74%
BananaFarm, DartMonkey, MortarMonkey 146 87 59 59.59% 0.52% 51.63%
BananaFarm, BoomerangMonkey, SniperMonkey 70 44 26 62.86% 0.25% 51.54%
BananaFarm, IceMonkey, MonkeySub 1175 628 547 53.45% 4.21% 50.59%
MonkeyBuccaneer, SpikeFactory, SuperMonkey 80 49 31 61.25% 0.29% 50.57%
BananaFarm, MonkeySub, WizardMonkey 120 71 49 59.17% 0.43% 50.37%
EngineerMonkey, TackShooter, WizardMonkey 147 85 62 57.82% 0.53% 49.84%
BananaFarm, DartMonkey, SniperMonkey 93 55 38 59.14% 0.33% 49.15%
DartlingGunner, HeliPilot, MortarMonkey 34 22 12 64.71% 0.12% 48.64%
BananaFarm, DartMonkey, WizardMonkey 176 97 79 55.11% 0.63% 47.77%
DartMonkey, MonkeyBuccaneer, WizardMonkey 35 22 13 62.86% 0.13% 46.85%
BananaFarm, BoomerangMonkey, MonkeySub 174 94 80 54.02% 0.62% 46.62%
DartMonkey, SpikeFactory, WizardMonkey 82 47 35 57.32% 0.29% 46.61%
BananaFarm, MonkeySub, SuperMonkey 120 66 54 55.00% 0.43% 46.10%
BananaFarm, EngineerMonkey, WizardMonkey 85 48 37 56.47% 0.30% 45.93%
GlueGunner, MonkeyBuccaneer, SniperMonkey 45 27 18 60.00% 0.16% 45.69%
MonkeyAce, SniperMonkey, WizardMonkey 34 21 13 61.76% 0.12% 45.43%
Druid, SniperMonkey, SuperMonkey 55 32 23 58.18% 0.20% 45.15%
MonkeyBuccaneer, SpikeFactory, WizardMonkey 135 72 63 53.33% 0.48% 44.92%
BananaFarm, DartlingGunner, SpikeFactory 85 47 38 55.29% 0.30% 44.72%
BoomerangMonkey, MonkeyBuccaneer, SpikeFactory 46 27 19 58.70% 0.16% 44.47%
BananaFarm, DartlingGunner, GlueGunner 60 34 26 56.67% 0.21% 44.13%
BananaFarm, TackShooter, WizardMonkey 372 183 189 49.19% 1.33% 44.11%
BananaFarm, BoomerangMonkey, WizardMonkey 135 70 65 51.85% 0.48% 43.42%
DartlingGunner, SniperMonkey, SpikeFactory 72 39 33 54.17% 0.26% 42.66%
BoomerangMonkey, MonkeyBuccaneer, WizardMonkey 32 19 13 59.38% 0.11% 42.36%
DartMonkey, MonkeyVillage, SpikeFactory 32 19 13 59.38% 0.11% 42.36%
DartMonkey, MonkeyVillage, SniperMonkey 52 29 23 55.77% 0.19% 42.27%
BananaFarm, BombShooter, DartlingGunner 46 26 20 56.52% 0.16% 42.20%
BananaFarm, DartMonkey, NinjaMonkey 40 23 17 57.50% 0.14% 42.18%
BananaFarm, MonkeySub, SpikeFactory 302 143 159 47.35% 1.08% 41.72%
BananaFarm, MonkeyBuccaneer, SpikeFactory 178 87 91 48.88% 0.64% 41.53%
BananaFarm, MonkeyBuccaneer, TackShooter 39 22 17 56.41% 0.14% 40.85%
DartMonkey, NinjaMonkey, SniperMonkey 35 20 15 57.14% 0.13% 40.75%
DartMonkey, Druid, SpikeFactory 74 38 36 51.35% 0.27% 39.96%
BananaFarm, NinjaMonkey, WizardMonkey 90 45 45 50.00% 0.32% 39.67%
BananaFarm, DartlingGunner, SuperMonkey 144 68 76 47.22% 0.52% 39.07%
DartMonkey, MonkeyBuccaneer, SpikeFactory 87 43 44 49.43% 0.31% 38.92%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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