season_30_matches: cobra_command

32 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	210	168	42	80.00%	4.62%	74.59%
BananaFarm, BoomerangMonkey, MortarMonkey	85	63	22	74.12%	1.87%	64.81%
BananaFarm, BombShooter, SpikeFactory	796	486	310	61.06%	17.53%	57.67%
DartlingGunner, MonkeyVillage, SuperMonkey	55	38	17	69.09%	1.21%	56.88%
BananaFarm, DartMonkey, SpikeFactory	46	31	15	67.39%	1.01%	53.84%
BananaFarm, HeliPilot, IceMonkey	32	21	11	65.63%	0.70%	49.17%
BananaFarm, BombShooter, MonkeySub	235	129	106	54.89%	5.17%	48.53%
BananaFarm, BoomerangMonkey, EngineerMonkey	53	32	21	60.38%	1.17%	47.21%
BananaFarm, Druid, MonkeySub	57	34	23	59.65%	1.25%	46.91%
BananaFarm, BombShooter, WizardMonkey	141	76	65	53.90%	3.10%	45.67%
BananaFarm, BombShooter, DartlingGunner	75	41	34	54.67%	1.65%	43.40%
BananaFarm, DartMonkey, WizardMonkey	49	28	21	57.14%	1.08%	43.29%
DartMonkey, Druid, MonkeyVillage	35	20	15	57.14%	0.77%	40.75%
BananaFarm, BombShooter, MortarMonkey	36	20	16	55.56%	0.79%	39.32%
BananaFarm, BoomerangMonkey, SpikeFactory	98	47	51	47.96%	2.16%	38.07%
BananaFarm, NinjaMonkey, WizardMonkey	56	27	29	48.21%	1.23%	35.13%
DartMonkey, MonkeyVillage, SuperMonkey	28	15	13	53.57%	0.62%	35.10%
BananaFarm, BoomerangMonkey, NinjaMonkey	121	53	68	43.80%	2.66%	34.96%
BananaFarm, DartMonkey, MortarMonkey	24	13	11	54.17%	0.53%	34.23%
BananaFarm, TackShooter, WizardMonkey	147	59	88	40.14%	3.24%	32.21%
HeliPilot, IceMonkey, MonkeyVillage	38	18	20	47.37%	0.84%	31.49%
BananaFarm, BoomerangMonkey, WizardMonkey	41	19	22	46.34%	0.90%	31.08%
BananaFarm, BombShooter, NinjaMonkey	21	11	10	52.38%	0.46%	31.02%
IceMonkey, MonkeyVillage, TackShooter	22	11	11	50.00%	0.48%	29.11%
Alchemist, BananaFarm, NinjaMonkey	41	18	23	43.90%	0.90%	28.71%
SniperMonkey, SuperMonkey, WizardMonkey	20	10	10	50.00%	0.44%	28.09%
BoomerangMonkey, SniperMonkey, WizardMonkey	25	11	14	44.00%	0.55%	24.54%
BananaFarm, DartlingGunner, IceMonkey	28	12	16	42.86%	0.62%	24.53%
BananaFarm, SniperMonkey, WizardMonkey	55	18	37	32.73%	1.21%	20.33%
Alchemist, GlueGunner, NinjaMonkey	30	11	19	36.67%	0.66%	19.42%
GlueGunner, MonkeyVillage, TackShooter	42	14	28	33.33%	0.92%	19.08%
SniperMonkey, SpikeFactory, TackShooter	30	10	20	33.33%	0.66%	16.46%

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)

32 rows

Advanced export