season_31_matches: sun_palace

45 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	84	63	21	75.00%	1.26%	65.74%
BananaFarm, EngineerMonkey, MonkeyAce	1142	713	429	62.43%	17.08%	59.63%
BananaFarm, BombShooter, WizardMonkey	73	50	23	68.49%	1.09%	57.84%
BananaFarm, BoomerangMonkey, NinjaMonkey	206	128	78	62.14%	3.08%	55.51%
BananaFarm, BoomerangMonkey, EngineerMonkey	49	33	16	67.35%	0.73%	54.22%
BananaFarm, HeliPilot, IceMonkey	59	39	20	66.10%	0.88%	54.02%
DartlingGunner, MonkeyVillage, SuperMonkey	99	60	39	60.61%	1.48%	50.98%
BananaFarm, SniperMonkey, TackShooter	68	42	26	61.76%	1.02%	50.21%
BananaFarm, TackShooter, WizardMonkey	473	254	219	53.70%	7.07%	49.21%
EngineerMonkey, MonkeyAce, MonkeyVillage	125	72	53	57.60%	1.87%	48.94%
BananaFarm, EngineerMonkey, SuperMonkey	139	75	64	53.96%	2.08%	45.67%
BananaFarm, NinjaMonkey, WizardMonkey	70	40	30	57.14%	1.05%	45.55%
BananaFarm, DartMonkey, GlueGunner	27	17	10	62.96%	0.40%	44.75%
BananaFarm, BoomerangMonkey, SpikeFactory	90	49	41	54.44%	1.35%	44.16%
IceMonkey, SniperMonkey, SuperMonkey	33	20	13	60.61%	0.49%	43.93%
BananaFarm, BoomerangMonkey, WizardMonkey	68	36	32	52.94%	1.02%	41.08%
GlueGunner, HeliPilot, MonkeyVillage	109	54	55	49.54%	1.63%	40.15%
BananaFarm, BoomerangMonkey, SuperMonkey	36	20	16	55.56%	0.54%	39.32%
BananaFarm, SniperMonkey, WizardMonkey	59	30	29	50.85%	0.88%	38.09%
BananaFarm, EngineerMonkey, SpikeFactory	37	20	17	54.05%	0.55%	38.00%
DartlingGunner, Druid, SpikeFactory	35	19	16	54.29%	0.52%	37.78%
BananaFarm, IceMonkey, NinjaMonkey	44	23	21	52.27%	0.66%	37.51%
GlueGunner, MonkeyVillage, NinjaMonkey	42	22	20	52.38%	0.63%	37.28%
BananaFarm, BombShooter, SpikeFactory	25	14	11	56.00%	0.37%	36.54%
BananaFarm, DartlingGunner, NinjaMonkey	42	21	21	50.00%	0.63%	34.88%
EngineerMonkey, TackShooter, WizardMonkey	33	17	16	51.52%	0.49%	34.46%
BananaFarm, GlueGunner, TackShooter	22	12	10	54.55%	0.33%	33.74%
BananaFarm, MonkeyAce, WizardMonkey	29	15	14	51.72%	0.43%	33.54%
BananaFarm, DartlingGunner, IceMonkey	43	20	23	46.51%	0.64%	31.60%
IceMonkey, MonkeyVillage, NinjaMonkey	51	23	28	45.10%	0.76%	31.44%
GlueGunner, MonkeyVillage, TackShooter	161	62	99	38.51%	2.41%	30.99%
HeliPilot, IceMonkey, MonkeyVillage	104	42	62	40.38%	1.56%	30.95%
BananaFarm, BoomerangMonkey, MonkeySub	29	14	15	48.28%	0.43%	30.09%
BoomerangMonkey, SniperMonkey, SuperMonkey	32	15	17	46.88%	0.48%	29.58%
BananaFarm, EngineerMonkey, WizardMonkey	46	20	26	43.48%	0.69%	29.15%
BananaFarm, MortarMonkey, TackShooter	22	11	11	50.00%	0.33%	29.11%
IceMonkey, MonkeyVillage, TackShooter	20	10	10	50.00%	0.30%	28.09%
BoomerangMonkey, SniperMonkey, WizardMonkey	21	10	11	47.62%	0.31%	26.26%
DartMonkey, GlueGunner, MonkeyVillage	35	14	21	40.00%	0.52%	23.77%
SniperMonkey, SpikeFactory, TackShooter	29	12	17	41.38%	0.43%	23.45%
BananaFarm, Druid, MonkeySub	34	13	21	38.24%	0.51%	21.90%
SniperMonkey, TackShooter, WizardMonkey	34	13	21	38.24%	0.51%	21.90%
Alchemist, BananaFarm, NinjaMonkey	41	15	26	36.59%	0.61%	21.84%
BananaFarm, BombShooter, MonkeySub	31	11	20	35.48%	0.46%	18.64%
BananaFarm, BoomerangMonkey, SniperMonkey	39	13	26	33.33%	0.58%	18.54%

Advanced export

JSON shape: default, array, newline-delimited

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

sun_palace_loadouts (view)

45 rows

Advanced export