season_31_matches: cobra_command

30 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, SpikeFactory	100	72	28	72.00%	2.08%	63.20%
BananaFarm, BoomerangMonkey, MortarMonkey	66	48	18	72.73%	1.37%	61.98%
BananaFarm, BombShooter, SpikeFactory	889	562	327	63.22%	18.51%	60.05%
DartlingGunner, MonkeyVillage, SuperMonkey	88	60	28	68.18%	1.83%	58.45%
BananaFarm, EngineerMonkey, MonkeyAce	144	94	50	65.28%	3.00%	57.50%
BananaFarm, DartMonkey, WizardMonkey	58	38	20	65.52%	1.21%	53.28%
BananaFarm, BoomerangMonkey, NinjaMonkey	71	44	27	61.97%	1.48%	50.68%
BananaFarm, BoomerangMonkey, EngineerMonkey	42	27	15	64.29%	0.87%	49.79%
BananaFarm, BombShooter, WizardMonkey	127	74	53	58.27%	2.64%	49.69%
BananaFarm, BombShooter, MortarMonkey	63	38	25	60.32%	1.31%	48.24%
BananaFarm, EngineerMonkey, WizardMonkey	28	18	10	64.29%	0.58%	46.54%
BananaFarm, SniperMonkey, SuperMonkey	33	20	13	60.61%	0.69%	43.93%
BananaFarm, HeliPilot, IceMonkey	48	27	21	56.25%	1.00%	42.22%
BananaFarm, BombShooter, NinjaMonkey	57	31	26	54.39%	1.19%	41.46%
DartMonkey, MonkeyVillage, SuperMonkey	25	15	10	60.00%	0.52%	40.80%
BananaFarm, BoomerangMonkey, SniperMonkey	35	20	15	57.14%	0.73%	40.75%
BananaFarm, BombShooter, MonkeySub	161	76	85	47.20%	3.35%	39.49%
BananaFarm, BoomerangMonkey, WizardMonkey	47	25	22	53.19%	0.98%	38.93%
HeliPilot, IceMonkey, MonkeyVillage	110	52	58	47.27%	2.29%	37.94%
BananaFarm, TackShooter, WizardMonkey	187	82	105	43.85%	3.89%	36.74%
BananaFarm, SniperMonkey, WizardMonkey	45	22	23	48.89%	0.94%	34.28%
BananaFarm, BombShooter, DartlingGunner	56	26	30	46.43%	1.17%	33.37%
IceMonkey, MonkeyVillage, TackShooter	39	19	20	48.72%	0.81%	33.03%
DartMonkey, GlueGunner, MonkeyVillage	21	11	10	52.38%	0.44%	31.02%
MonkeyVillage, SniperMonkey, SuperMonkey	31	15	16	48.39%	0.65%	30.79%
BananaFarm, NinjaMonkey, WizardMonkey	34	16	18	47.06%	0.71%	30.28%
BananaFarm, BombShooter, SuperMonkey	23	11	12	47.83%	0.48%	27.41%
SniperMonkey, TackShooter, WizardMonkey	27	12	15	44.44%	0.56%	25.70%
BananaFarm, DartMonkey, SpikeFactory	28	11	17	39.29%	0.58%	21.20%
GlueGunner, MonkeyVillage, TackShooter	80	24	56	30.00%	1.67%	19.96%

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)

30 rows

Advanced export