season_25_matches: castle_ruins

35 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	139	108	31	77.70%	3.22%	70.78%
BananaFarm, Druid, MortarMonkey	49	38	11	77.55%	1.14%	65.87%
BananaFarm, BoomerangMonkey, MortarMonkey	44	34	10	77.27%	1.02%	64.89%
BananaFarm, BoomerangMonkey, NinjaMonkey	50	36	14	72.00%	1.16%	59.55%
BananaFarm, SniperMonkey, TackShooter	62	41	21	66.13%	1.44%	54.35%
BananaFarm, TackShooter, WizardMonkey	111	70	41	63.06%	2.57%	54.08%
BananaFarm, DartMonkey, MortarMonkey	65	42	23	64.62%	1.51%	52.99%
BananaFarm, MonkeySub, TackShooter	44	29	15	65.91%	1.02%	51.90%
BananaFarm, DartlingGunner, IceMonkey	48	31	17	64.58%	1.11%	51.05%
EngineerMonkey, TackShooter, WizardMonkey	32	21	11	65.63%	0.74%	49.17%
BananaFarm, Druid, MonkeySub	203	109	94	53.69%	4.71%	46.84%
BananaFarm, DartMonkey, GlueGunner	119	66	53	55.46%	2.76%	46.53%
BananaFarm, BoomerangMonkey, SniperMonkey	31	19	12	61.29%	0.72%	44.14%
BananaFarm, BombShooter, DartlingGunner	39	23	16	58.97%	0.90%	43.54%
BananaFarm, MonkeySub, SuperMonkey	38	22	16	57.89%	0.88%	42.20%
DartlingGunner, Druid, SpikeFactory	55	30	25	54.55%	1.27%	41.39%
BananaFarm, MortarMonkey, TackShooter	45	25	20	55.56%	1.04%	41.04%
BananaFarm, BombShooter, WizardMonkey	75	39	36	52.00%	1.74%	40.69%
BananaFarm, BombShooter, DartMonkey	30	17	13	56.67%	0.70%	38.93%
IceMonkey, MonkeyVillage, NinjaMonkey	23	13	10	56.52%	0.53%	36.26%
GlueGunner, MonkeyVillage, TackShooter	81	38	43	46.91%	1.88%	36.05%
DartMonkey, GlueGunner, MonkeyVillage	105	47	58	44.76%	2.43%	35.25%
GlueGunner, HeliPilot, MonkeyVillage	71	33	38	46.48%	1.65%	34.88%
BoomerangMonkey, GlueGunner, MonkeyVillage	26	14	12	53.85%	0.60%	34.68%
BananaFarm, BoomerangMonkey, WizardMonkey	27	14	13	51.85%	0.63%	33.00%
DartlingGunner, Druid, MonkeyVillage	36	17	19	47.22%	0.83%	30.91%
GlueGunner, MonkeyVillage, NinjaMonkey	88	35	53	39.77%	2.04%	29.55%
MonkeyVillage, SniperMonkey, TackShooter	32	14	18	43.75%	0.74%	26.56%
BananaFarm, DartlingGunner, SuperMonkey	50	20	30	40.00%	1.16%	26.42%
DartlingGunner, MonkeyVillage, SuperMonkey	30	13	17	43.33%	0.70%	25.60%
Alchemist, NinjaMonkey, SniperMonkey	22	10	12	45.45%	0.51%	24.65%
Druid, MonkeySub, SpikeFactory	31	13	18	41.94%	0.72%	24.56%
BananaFarm, SniperMonkey, WizardMonkey	28	11	17	39.29%	0.65%	21.20%
BananaFarm, GlueGunner, TackShooter	32	12	20	37.50%	0.74%	20.73%
Alchemist, GlueGunner, NinjaMonkey	37	12	25	32.43%	0.86%	17.35%

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)

35 rows

Advanced export