building_site_scene_loadouts (view)

70 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, DartMonkey, MortarMonkey 2615 1639 976 62.68% 17.08% 60.82%
MortarMonkey, SniperMonkey, TackShooter 176 116 60 65.91% 1.15% 58.91%
BananaFarm, EngineerMonkey, WizardMonkey 39 28 11 71.79% 0.25% 57.67%
BananaFarm, BoomerangMonkey, IceMonkey 56 39 17 69.64% 0.37% 57.60%
BananaFarm, BombShooter, TackShooter 152 98 54 64.47% 0.99% 56.87%
BananaFarm, DartMonkey, SpikeFactory 285 178 107 62.46% 1.86% 56.83%
BananaFarm, DartMonkey, SniperMonkey 199 124 75 62.31% 1.30% 55.58%
BananaFarm, TackShooter, WizardMonkey 2172 1245 927 57.32% 14.19% 55.24%
SniperMonkey, SpikeFactory, WizardMonkey 32 22 10 68.75% 0.21% 52.69%
Alchemist, DartlingGunner, SuperMonkey 74 47 27 63.51% 0.48% 52.55%
BananaFarm, MortarMonkey, TackShooter 1353 729 624 53.88% 8.84% 51.22%
DartMonkey, GlueGunner, SniperMonkey 40 26 14 65.00% 0.26% 50.22%
BananaFarm, BombShooter, WizardMonkey 95 56 39 58.95% 0.62% 49.06%
MonkeyBuccaneer, MortarMonkey, TackShooter 184 102 82 55.43% 1.20% 48.25%
BananaFarm, BoomerangMonkey, NinjaMonkey 109 62 47 56.88% 0.71% 47.58%
BananaFarm, DartMonkey, NinjaMonkey 67 39 28 58.21% 0.44% 46.40%
BananaFarm, SniperMonkey, TackShooter 203 107 96 52.71% 1.33% 45.84%
BananaFarm, DartMonkey, WizardMonkey 271 140 131 51.66% 1.77% 45.71%
BananaFarm, GlueGunner, TackShooter 257 133 124 51.75% 1.68% 45.64%
DartMonkey, NinjaMonkey, SniperMonkey 27 17 10 62.96% 0.18% 44.75%
BananaFarm, DartMonkey, GlueGunner 243 124 119 51.03% 1.59% 44.74%
SpikeFactory, TackShooter, WizardMonkey 138 71 67 51.45% 0.90% 43.11%
BananaFarm, DartMonkey, MonkeySub 60 33 27 55.00% 0.39% 42.41%
HeliPilot, MortarMonkey, TackShooter 34 20 14 58.82% 0.22% 42.28%
HeliPilot, IceMonkey, NinjaMonkey 48 27 21 56.25% 0.31% 42.22%
BananaFarm, SniperMonkey, WizardMonkey 148 69 79 46.62% 0.97% 38.58%
EngineerMonkey, IceMonkey, SniperMonkey 37 20 17 54.05% 0.24% 38.00%
Alchemist, MonkeyAce, MortarMonkey 52 26 26 50.00% 0.34% 36.41%
BananaFarm, BoomerangMonkey, GlueGunner 41 21 20 51.22% 0.27% 35.92%
SniperMonkey, SpikeFactory, TackShooter 39 20 19 51.28% 0.25% 35.59%
BananaFarm, NinjaMonkey, WizardMonkey 75 35 40 46.67% 0.49% 35.38%
BananaFarm, SpikeFactory, TackShooter 37 19 18 51.35% 0.24% 35.25%
MonkeyBuccaneer, TackShooter, WizardMonkey 38 19 19 50.00% 0.25% 34.10%
DartMonkey, MonkeyBuccaneer, MortarMonkey 22 12 10 54.55% 0.14% 33.74%
BananaFarm, BoomerangMonkey, WizardMonkey 101 43 58 42.57% 0.66% 32.93%
BoomerangMonkey, NinjaMonkey, SniperMonkey 28 14 14 50.00% 0.18% 31.48%
BananaFarm, BoomerangMonkey, MortarMonkey 104 42 62 40.38% 0.68% 30.95%
GlueGunner, HeliPilot, MonkeyVillage 91 37 54 40.66% 0.59% 30.57%
BananaFarm, DartMonkey, IceMonkey 39 18 21 46.15% 0.25% 30.51%
BananaFarm, BoomerangMonkey, SpikeFactory 40 18 22 45.00% 0.26% 29.58%
GlueGunner, MortarMonkey, TackShooter 32 15 17 46.88% 0.21% 29.58%
DartMonkey, MonkeyBuccaneer, SniperMonkey 27 13 14 48.15% 0.18% 29.30%
BoomerangMonkey, SniperMonkey, SpikeFactory 22 11 11 50.00% 0.14% 29.11%
GlueGunner, MonkeyVillage, TackShooter 119 45 74 37.82% 0.78% 29.10%
SniperMonkey, TackShooter, WizardMonkey 75 30 45 40.00% 0.49% 28.91%
Alchemist, BananaFarm, DartMonkey 25 12 13 48.00% 0.16% 28.42%
NinjaMonkey, SniperMonkey, TackShooter 25 12 13 48.00% 0.16% 28.42%
BananaFarm, BoomerangMonkey, SniperMonkey 62 25 37 40.32% 0.41% 28.11%
GlueGunner, SniperMonkey, TackShooter 23 11 12 47.83% 0.15% 27.41%
MonkeyVillage, TackShooter, WizardMonkey 23 11 12 47.83% 0.15% 27.41%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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