s24+_matches: castle_ruins_loadouts: 226 rows

226 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	515	380	135	73.79%	1.52%	69.99%
BananaFarm, EngineerMonkey, MonkeyAce	2116	1425	691	67.34%	6.26%	65.35%
BananaFarm, Druid, MortarMonkey	156	106	50	67.95%	0.46%	60.63%
BoomerangMonkey, EngineerMonkey, NinjaMonkey	53	37	16	69.81%	0.16%	57.45%
DartlingGunner, MonkeyVillage, SuperMonkey	645	394	251	61.09%	1.91%	57.32%
BananaFarm, TackShooter, WizardMonkey	2349	1351	998	57.51%	6.95%	55.51%
DartlingGunner, HeliPilot, MortarMonkey	42	29	13	69.05%	0.12%	55.07%
BananaFarm, DartlingGunner, IceMonkey	430	256	174	59.53%	1.27%	54.90%
EngineerMonkey, TackShooter, WizardMonkey	173	106	67	61.27%	0.51%	54.01%
BananaFarm, EngineerMonkey, WizardMonkey	183	111	72	60.66%	0.54%	53.58%
BananaFarm, DartlingGunner, EngineerMonkey	59	38	21	64.41%	0.17%	52.19%
DartMonkey, SniperMonkey, SuperMonkey	34	23	11	67.65%	0.10%	51.92%
BananaFarm, BombShooter, WizardMonkey	431	243	188	56.38%	1.28%	51.70%
BananaFarm, SniperMonkey, TackShooter	449	251	198	55.90%	1.33%	51.31%
BananaFarm, DartMonkey, MortarMonkey	256	146	110	57.03%	0.76%	50.97%
BananaFarm, BoomerangMonkey, NinjaMonkey	490	271	219	55.31%	1.45%	50.90%
BananaFarm, DartMonkey, WizardMonkey	119	71	48	59.66%	0.35%	50.85%
BananaFarm, Druid, MonkeySub	2141	1132	1009	52.87%	6.34%	50.76%
BoomerangMonkey, IceMonkey, MonkeySub	57	36	21	63.16%	0.17%	50.64%
BananaFarm, DartMonkey, GlueGunner	541	296	245	54.71%	1.60%	50.52%
BananaFarm, MortarMonkey, TackShooter	446	243	203	54.48%	1.32%	49.86%
BananaFarm, BoomerangMonkey, MonkeySub	240	134	106	55.83%	0.71%	49.55%
BananaFarm, DartlingGunner, NinjaMonkey	351	191	160	54.42%	1.04%	49.21%
DartMonkey, GlueGunner, MonkeyVillage	477	256	221	53.67%	1.41%	49.19%
BananaFarm, DartMonkey, MonkeySub	95	56	39	58.95%	0.28%	49.06%
BananaFarm, MonkeySub, TackShooter	389	210	179	53.98%	1.15%	49.03%
BananaFarm, BoomerangMonkey, SniperMonkey	190	106	84	55.79%	0.56%	48.73%
IceMonkey, MonkeyVillage, SuperMonkey	43	27	16	62.79%	0.13%	48.34%
DartlingGunner, Druid, SpikeFactory	140	79	61	56.43%	0.41%	48.21%
GlueGunner, HeliPilot, MonkeyVillage	534	280	254	52.43%	1.58%	48.20%
BananaFarm, BombShooter, DartMonkey	56	34	22	60.71%	0.17%	47.92%
DartMonkey, IceMonkey, MonkeyVillage	62	37	25	59.68%	0.18%	47.47%
BananaFarm, BombShooter, SniperMonkey	42	26	16	61.90%	0.12%	47.22%
BananaFarm, BombShooter, MonkeyVillage	53	32	21	60.38%	0.16%	47.21%
BananaFarm, BoomerangMonkey, WizardMonkey	295	153	142	51.86%	0.87%	46.16%
BoomerangMonkey, GlueGunner, MonkeySub	34	21	13	61.76%	0.10%	45.43%
DartlingGunner, MonkeyVillage, NinjaMonkey	49	29	20	59.18%	0.15%	45.42%
BoomerangMonkey, GlueGunner, SniperMonkey	51	30	21	58.82%	0.15%	45.32%
BananaFarm, DartMonkey, IceMonkey	55	32	23	58.18%	0.16%	45.15%
MonkeyAce, SniperMonkey, WizardMonkey	75	42	33	56.00%	0.22%	44.77%
BananaFarm, NinjaMonkey, WizardMonkey	193	99	94	51.30%	0.57%	44.24%
GlueGunner, MonkeySub, SuperMonkey	96	52	44	54.17%	0.28%	44.20%
BananaFarm, MonkeySub, SuperMonkey	105	56	49	53.33%	0.31%	43.79%
BananaFarm, DartlingGunner, GlueGunner	86	46	40	53.49%	0.25%	42.95%
BananaFarm, BombShooter, MonkeySub	234	115	119	49.15%	0.69%	42.74%
DartMonkey, GlueGunner, SuperMonkey	28	17	11	60.71%	0.08%	42.62%
MonkeyAce, MonkeyBuccaneer, MonkeySub	28	17	11	60.71%	0.08%	42.62%
BoomerangMonkey, SniperMonkey, SpikeFactory	60	33	27	55.00%	0.18%	42.41%
GlueGunner, SniperMonkey, TackShooter	95	49	46	51.58%	0.28%	41.53%
BananaFarm, SniperMonkey, WizardMonkey	293	138	155	47.10%	0.87%	41.38%

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW castle_ruins_loadouts AS 
WITH castle_ruins AS
    (SELECT *
    FROM matches
    WHERE map = 'castle_ruins')
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 castle_ruins) * 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 castle_ruins
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM castle_ruins)
            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;

castle_ruins_loadouts (view)

226 rows

Advanced export