season_29_matches: cobra_command

32 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	62	49	13	79.03%	1.11%	68.90%
BananaFarm, DartMonkey, SpikeFactory	103	79	24	76.70%	1.85%	68.53%
BananaFarm, EngineerMonkey, MonkeyAce	218	160	58	73.39%	3.92%	67.53%
DartlingGunner, MonkeyVillage, SuperMonkey	37	27	10	72.97%	0.66%	58.66%
BananaFarm, BombShooter, SpikeFactory	984	587	397	59.65%	17.67%	56.59%
BananaFarm, BoomerangMonkey, EngineerMonkey	91	60	31	65.93%	1.63%	56.20%
BombShooter, DartlingGunner, SpikeFactory	35	24	11	68.57%	0.63%	53.19%
BananaFarm, Druid, MonkeySub	75	48	27	64.00%	1.35%	53.14%
BananaFarm, BombShooter, SniperMonkey	43	28	15	65.12%	0.77%	50.87%
BananaFarm, BombShooter, MonkeySub	525	286	239	54.48%	9.43%	50.22%
BananaFarm, DartMonkey, WizardMonkey	52	32	20	61.54%	0.93%	48.32%
BananaFarm, BoomerangMonkey, NinjaMonkey	172	91	81	52.91%	3.09%	45.45%
BombShooter, MonkeyVillage, SpikeFactory	57	33	24	57.89%	1.02%	45.08%
BananaFarm, BombShooter, MortarMonkey	50	28	22	56.00%	0.90%	42.24%
BananaFarm, BoomerangMonkey, SpikeFactory	127	64	63	50.39%	2.28%	41.70%
BananaFarm, DartMonkey, MortarMonkey	73	38	35	52.05%	1.31%	40.59%
BananaFarm, DartMonkey, GlueGunner	47	25	22	53.19%	0.84%	38.93%
DartMonkey, GlueGunner, MonkeyVillage	25	14	11	56.00%	0.45%	36.54%
BananaFarm, BombShooter, WizardMonkey	118	52	66	44.07%	2.12%	35.11%
Alchemist, NinjaMonkey, SniperMonkey	24	13	11	54.17%	0.43%	34.23%
BananaFarm, TackShooter, WizardMonkey	132	56	76	42.42%	2.37%	33.99%
BananaFarm, IceMonkey, WizardMonkey	24	12	12	50.00%	0.43%	30.00%
BananaFarm, NinjaMonkey, WizardMonkey	85	34	51	40.00%	1.53%	29.59%
BananaFarm, BombShooter, DartlingGunner	53	22	31	41.51%	0.95%	28.24%
IceMonkey, MonkeyVillage, TackShooter	26	12	14	46.15%	0.47%	26.99%
BananaFarm, BoomerangMonkey, WizardMonkey	33	14	19	42.42%	0.59%	25.56%
BananaFarm, SniperMonkey, WizardMonkey	42	16	26	38.10%	0.75%	23.41%
DartlingGunner, NinjaMonkey, SpikeFactory	26	11	15	42.31%	0.47%	23.32%
HeliPilot, IceMonkey, NinjaMonkey	23	10	13	43.48%	0.41%	23.22%
GlueGunner, MonkeyVillage, TackShooter	52	18	34	34.62%	0.93%	21.68%
Alchemist, BananaFarm, NinjaMonkey	33	12	21	36.36%	0.59%	19.95%
BananaFarm, BombShooter, SuperMonkey	26	10	16	38.46%	0.47%	19.76%

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