season_26_matches: cobra_command

40 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	104	81	23	77.88%	1.76%	69.91%
BananaFarm, BoomerangMonkey, MortarMonkey	57	42	15	73.68%	0.96%	62.25%
DartlingGunner, MonkeyVillage, SuperMonkey	80	53	27	66.25%	1.35%	55.89%
BananaFarm, BombShooter, SpikeFactory	1012	591	421	58.40%	17.12%	55.36%
BananaFarm, DartMonkey, MortarMonkey	117	73	44	62.39%	1.98%	53.62%
BananaFarm, BombShooter, MortarMonkey	93	58	35	62.37%	1.57%	52.52%
BananaFarm, DartMonkey, GlueGunner	178	103	75	57.87%	3.01%	50.61%
BananaFarm, DartMonkey, SpikeFactory	45	29	16	64.44%	0.76%	50.46%
BombShooter, MonkeySub, SpikeFactory	28	18	10	64.29%	0.47%	46.54%
Alchemist, HeliPilot, NinjaMonkey	50	30	20	60.00%	0.85%	46.42%
BananaFarm, BoomerangMonkey, SpikeFactory	52	31	21	59.62%	0.88%	46.28%
BananaFarm, SniperMonkey, WizardMonkey	38	23	15	60.53%	0.64%	44.98%
BananaFarm, BombShooter, SuperMonkey	44	26	18	59.09%	0.74%	44.56%
BananaFarm, BombShooter, WizardMonkey	161	84	77	52.17%	2.72%	44.46%
BananaFarm, DartMonkey, WizardMonkey	41	24	17	58.54%	0.69%	43.46%
GlueGunner, HeliPilot, MonkeyVillage	152	78	74	51.32%	2.57%	43.37%
BombShooter, MonkeyVillage, SpikeFactory	47	27	20	57.45%	0.80%	43.31%
BananaFarm, BombShooter, MonkeySub	200	100	100	50.00%	3.38%	43.07%
BombShooter, SpikeFactory, WizardMonkey	40	23	17	57.50%	0.68%	42.18%
BananaFarm, BoomerangMonkey, SniperMonkey	31	17	14	54.84%	0.52%	37.32%
BombShooter, MortarMonkey, SpikeFactory	27	15	12	55.56%	0.46%	36.81%
GlueGunner, MonkeyVillage, NinjaMonkey	66	31	35	46.97%	1.12%	34.93%
Alchemist, GlueGunner, NinjaMonkey	41	20	21	48.78%	0.69%	33.48%
DartMonkey, GlueGunner, MonkeyVillage	77	34	43	44.16%	1.30%	33.06%
Druid, SniperMonkey, SuperMonkey	21	11	10	52.38%	0.36%	31.02%
BananaFarm, BombShooter, SniperMonkey	31	15	16	48.39%	0.52%	30.79%
BananaFarm, SniperMonkey, TackShooter	31	15	16	48.39%	0.52%	30.79%
BombShooter, HeliPilot, MortarMonkey	29	14	15	48.28%	0.49%	30.09%
BananaFarm, BombShooter, DartlingGunner	25	12	13	48.00%	0.42%	28.42%
Alchemist, NinjaMonkey, SniperMonkey	20	10	10	50.00%	0.34%	28.09%
GlueGunner, MonkeyVillage, TackShooter	104	37	67	35.58%	1.76%	26.38%
BananaFarm, BoomerangMonkey, WizardMonkey	21	10	11	47.62%	0.36%	26.26%
BananaFarm, TackShooter, WizardMonkey	75	26	49	34.67%	1.27%	23.90%
SniperMonkey, TackShooter, WizardMonkey	23	10	13	43.48%	0.39%	23.22%
BananaFarm, DartlingGunner, SuperMonkey	47	16	31	34.04%	0.80%	20.50%
Alchemist, DartlingGunner, SpikeFactory	26	10	16	38.46%	0.44%	19.76%
BananaFarm, Druid, MonkeySub	37	12	25	32.43%	0.63%	17.35%
Alchemist, BananaFarm, NinjaMonkey	60	16	44	26.67%	1.02%	15.48%
MonkeyVillage, SniperMonkey, TackShooter	32	10	22	31.25%	0.54%	15.19%
HeliPilot, MonkeyVillage, SuperMonkey	45	11	34	24.44%	0.76%	11.89%

Advanced export

JSON shape: default, array, newline-delimited

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

cobra_command_loadouts (view)

40 rows

Advanced export