season_27_matches: cobra_command

36 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	79	59	20	74.68%	1.61%	65.09%
BananaFarm, BombShooter, SpikeFactory	811	499	312	61.53%	16.52%	58.18%
BananaFarm, DartMonkey, MortarMonkey	79	52	27	65.82%	1.61%	55.36%
BananaFarm, BombShooter, WizardMonkey	173	107	66	61.85%	3.52%	54.61%
BananaFarm, BombShooter, MonkeySub	134	81	53	60.45%	2.73%	52.17%
BananaFarm, EngineerMonkey, MonkeyAce	64	40	24	62.50%	1.30%	50.64%
BananaFarm, BoomerangMonkey, NinjaMonkey	39	25	14	64.10%	0.79%	49.05%
BananaFarm, DartMonkey, GlueGunner	136	77	59	56.62%	2.77%	48.29%
BananaFarm, BombShooter, MonkeyVillage	36	22	14	61.11%	0.73%	45.19%
BananaFarm, BombShooter, SniperMonkey	27	17	10	62.96%	0.55%	44.75%
DartlingGunner, MonkeyVillage, SuperMonkey	101	54	47	53.47%	2.06%	43.74%
BananaFarm, BoomerangMonkey, EngineerMonkey	43	25	18	58.14%	0.88%	43.39%
BananaFarm, Druid, MonkeySub	28	17	11	60.71%	0.57%	42.62%
BombShooter, MonkeyVillage, MortarMonkey	30	18	12	60.00%	0.61%	42.47%
DartMonkey, GlueGunner, MonkeyVillage	83	43	40	51.81%	1.69%	41.06%
GlueGunner, HeliPilot, MonkeyVillage	127	63	64	49.61%	2.59%	40.91%
Alchemist, BananaFarm, NinjaMonkey	53	27	26	50.94%	1.08%	37.48%
BananaFarm, BoomerangMonkey, SpikeFactory	59	29	30	49.15%	1.20%	36.40%
BananaFarm, BombShooter, MortarMonkey	57	28	29	49.12%	1.16%	36.14%
GlueGunner, MonkeyVillage, TackShooter	91	42	49	46.15%	1.85%	35.91%
BananaFarm, BombShooter, SuperMonkey	28	15	13	53.57%	0.57%	35.10%
BombShooter, MonkeyVillage, SpikeFactory	32	16	16	50.00%	0.65%	32.68%
BombShooter, MonkeySub, SpikeFactory	30	15	15	50.00%	0.61%	32.11%
GlueGunner, MonkeyVillage, NinjaMonkey	32	15	17	46.88%	0.65%	29.58%
BombShooter, HeliPilot, MortarMonkey	22	11	11	50.00%	0.45%	29.11%
BananaFarm, TackShooter, WizardMonkey	78	31	47	39.74%	1.59%	28.88%
Druid, SniperMonkey, SuperMonkey	20	10	10	50.00%	0.41%	28.09%
BananaFarm, DartMonkey, IceMonkey	23	11	12	47.83%	0.47%	27.41%
HeliPilot, MonkeyVillage, SuperMonkey	41	17	24	41.46%	0.84%	26.38%
DartlingGunner, SpikeFactory, SuperMonkey	21	10	11	47.62%	0.43%	26.26%
BananaFarm, DartMonkey, SpikeFactory	24	11	13	45.83%	0.49%	25.90%
Alchemist, HeliPilot, NinjaMonkey	30	12	18	40.00%	0.61%	22.47%
SniperMonkey, SpikeFactory, WizardMonkey	24	10	14	41.67%	0.49%	21.94%
BananaFarm, SniperMonkey, WizardMonkey	31	12	19	38.71%	0.63%	21.56%
SpikeFactory, TackShooter, WizardMonkey	32	10	22	31.25%	0.65%	15.19%
BananaFarm, DartlingGunner, SuperMonkey	34	10	24	29.41%	0.69%	14.10%

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)

36 rows

Advanced export