season_29_matches: sun_palace

45 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	914	606	308	66.30%	15.43%	63.24%
BananaFarm, BoomerangMonkey, EngineerMonkey	99	70	29	70.71%	1.67%	61.74%
BananaFarm, BombShooter, WizardMonkey	95	66	29	69.47%	1.60%	60.21%
BananaFarm, BoomerangMonkey, MortarMonkey	66	46	20	69.70%	1.11%	58.61%
BananaFarm, TackShooter, WizardMonkey	306	169	137	55.23%	5.17%	49.66%
BananaFarm, BoomerangMonkey, NinjaMonkey	209	117	92	55.98%	3.53%	49.25%
GlueGunner, HeliPilot, MonkeyVillage	125	72	53	57.60%	2.11%	48.94%
BananaFarm, BoomerangMonkey, SpikeFactory	139	79	60	56.83%	2.35%	48.60%
BananaFarm, NinjaMonkey, WizardMonkey	147	80	67	54.42%	2.48%	46.37%
BananaFarm, MonkeySub, TackShooter	38	23	15	60.53%	0.64%	44.98%
IceMonkey, MonkeyVillage, NinjaMonkey	56	32	24	57.14%	0.95%	44.18%
DartMonkey, GlueGunner, MonkeyVillage	51	29	22	56.86%	0.86%	43.27%
BananaFarm, BombShooter, SpikeFactory	30	18	12	60.00%	0.51%	42.47%
BananaFarm, BoomerangMonkey, WizardMonkey	36	21	15	58.33%	0.61%	42.23%
BananaFarm, Druid, MonkeySub	101	52	49	51.49%	1.70%	41.74%
BananaFarm, BombShooter, MonkeySub	65	35	30	53.85%	1.10%	41.73%
BananaFarm, EngineerMonkey, SuperMonkey	41	23	18	56.10%	0.69%	40.91%
BananaFarm, EngineerMonkey, SpikeFactory	33	19	14	57.58%	0.56%	40.71%
GlueGunner, MonkeyVillage, TackShooter	158	73	85	46.20%	2.67%	38.43%
DartlingGunner, MonkeyVillage, SuperMonkey	53	27	26	50.94%	0.89%	37.48%
BananaFarm, BoomerangMonkey, MonkeySub	31	17	14	54.84%	0.52%	37.32%
Alchemist, HeliPilot, NinjaMonkey	27	15	12	55.56%	0.46%	36.81%
BananaFarm, IceMonkey, WizardMonkey	30	16	14	53.33%	0.51%	35.48%
BananaFarm, DartlingGunner, IceMonkey	34	17	17	50.00%	0.57%	33.19%
BombShooter, MonkeyVillage, SpikeFactory	45	21	24	46.67%	0.76%	32.09%
Alchemist, IceMonkey, NinjaMonkey	23	12	11	52.17%	0.39%	31.76%
GlueGunner, SniperMonkey, WizardMonkey	26	13	13	50.00%	0.44%	30.78%
SniperMonkey, SuperMonkey, TackShooter	26	13	13	50.00%	0.44%	30.78%
BananaFarm, BombShooter, SniperMonkey	34	16	18	47.06%	0.57%	30.28%
Alchemist, BananaFarm, NinjaMonkey	53	23	30	43.40%	0.89%	30.05%
BombShooter, MonkeyVillage, TackShooter	24	12	12	50.00%	0.41%	30.00%
BananaFarm, DartMonkey, SpikeFactory	35	16	19	45.71%	0.59%	29.21%
BananaFarm, BombShooter, MortarMonkey	25	12	13	48.00%	0.42%	28.42%
BananaFarm, EngineerMonkey, MonkeySub	34	15	19	44.12%	0.57%	27.43%
BananaFarm, SniperMonkey, TackShooter	27	12	15	44.44%	0.46%	25.70%
BananaFarm, DartMonkey, GlueGunner	43	17	26	39.53%	0.73%	24.92%
HeliPilot, IceMonkey, MonkeyVillage	35	14	21	40.00%	0.59%	23.77%
SniperMonkey, TackShooter, WizardMonkey	27	11	16	40.74%	0.46%	22.21%
BananaFarm, EngineerMonkey, WizardMonkey	24	10	14	41.67%	0.41%	21.94%
BananaFarm, SniperMonkey, WizardMonkey	59	20	39	33.90%	1.00%	21.82%
GlueGunner, MonkeyVillage, NinjaMonkey	28	11	17	39.29%	0.47%	21.20%
MonkeyVillage, SniperMonkey, TackShooter	32	12	20	37.50%	0.54%	20.73%
BananaFarm, DartlingGunner, SuperMonkey	27	10	17	37.04%	0.46%	18.82%
MonkeyVillage, TackShooter, WizardMonkey	28	10	18	35.71%	0.47%	17.97%
EngineerMonkey, TackShooter, WizardMonkey	38	12	26	31.58%	0.64%	16.80%

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