season_25_matches: cobra_command

39 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	74	58	16	78.38%	1.34%	69.00%
BananaFarm, BoomerangMonkey, MortarMonkey	61	43	18	70.49%	1.11%	59.05%
BananaFarm, BombShooter, SpikeFactory	939	577	362	61.45%	17.02%	58.34%
BananaFarm, BombShooter, MonkeySub	120	80	40	66.67%	2.18%	58.23%
BananaFarm, BoomerangMonkey, SniperMonkey	47	33	14	70.21%	0.85%	57.14%
DartlingGunner, Druid, SpikeFactory	40	26	14	65.00%	0.73%	50.22%
BombShooter, MonkeySub, SpikeFactory	28	18	10	64.29%	0.51%	46.54%
DartMonkey, IceMonkey, MonkeyVillage	49	28	21	57.14%	0.89%	43.29%
BananaFarm, BoomerangMonkey, SpikeFactory	57	31	26	54.39%	1.03%	41.46%
BananaFarm, BombShooter, WizardMonkey	142	70	72	49.30%	2.57%	41.07%
BananaFarm, BombShooter, DartlingGunner	29	17	12	58.62%	0.53%	40.70%
BananaFarm, DartMonkey, GlueGunner	99	50	49	50.51%	1.79%	40.66%
BombShooter, SpikeFactory, WizardMonkey	42	23	19	54.76%	0.76%	39.71%
Alchemist, DartlingGunner, SpikeFactory	30	17	13	56.67%	0.54%	38.93%
BananaFarm, DartMonkey, MortarMonkey	122	58	64	47.54%	2.21%	38.68%
BananaFarm, BombShooter, SuperMonkey	59	30	29	50.85%	1.07%	38.09%
BananaFarm, DartMonkey, SpikeFactory	62	31	31	50.00%	1.12%	37.55%
Alchemist, BombShooter, SpikeFactory	32	17	15	53.13%	0.58%	35.83%
BananaFarm, IceMonkey, NinjaMonkey	37	19	18	51.35%	0.67%	35.25%
GlueGunner, MonkeyVillage, TackShooter	71	33	38	46.48%	1.29%	34.88%
BananaFarm, BombShooter, MortarMonkey	40	20	20	50.00%	0.73%	34.50%
GlueGunner, MonkeyVillage, NinjaMonkey	127	53	74	41.73%	2.30%	33.16%
DartMonkey, GlueGunner, MonkeyVillage	77	34	43	44.16%	1.40%	33.06%
BombShooter, MonkeyVillage, SpikeFactory	55	25	30	45.45%	1.00%	32.29%
BananaFarm, DartMonkey, SniperMonkey	23	12	11	52.17%	0.42%	31.76%
BananaFarm, TackShooter, WizardMonkey	57	25	32	43.86%	1.03%	30.98%
Alchemist, NinjaMonkey, SniperMonkey	26	13	13	50.00%	0.47%	30.78%
SniperMonkey, SuperMonkey, WizardMonkey	29	14	15	48.28%	0.53%	30.09%
BananaFarm, SniperMonkey, WizardMonkey	33	15	18	45.45%	0.60%	28.47%
BoomerangMonkey, DartMonkey, SniperMonkey	20	10	10	50.00%	0.36%	28.09%
DartlingGunner, MonkeyVillage, SuperMonkey	31	14	17	45.16%	0.56%	27.64%
BoomerangMonkey, SniperMonkey, WizardMonkey	23	11	12	47.83%	0.42%	27.41%
BombShooter, HeliPilot, MortarMonkey	29	13	16	44.83%	0.53%	26.73%
SpikeFactory, TackShooter, WizardMonkey	29	13	16	44.83%	0.53%	26.73%
Alchemist, GlueGunner, NinjaMonkey	59	23	36	38.98%	1.07%	26.54%
SniperMonkey, SpikeFactory, WizardMonkey	27	11	16	40.74%	0.49%	22.21%
BananaFarm, Druid, MonkeySub	24	10	14	41.67%	0.44%	21.94%
GlueGunner, HeliPilot, MonkeyVillage	58	19	39	32.76%	1.05%	20.68%
Alchemist, BananaFarm, NinjaMonkey	28	10	18	35.71%	0.51%	17.97%

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)

39 rows

Advanced export