season_30_matches: sun_palace

42 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	910	606	304	66.59%	15.90%	63.53%
BananaFarm, BoomerangMonkey, MortarMonkey	87	60	27	68.97%	1.52%	59.24%
BananaFarm, BombShooter, WizardMonkey	86	58	28	67.44%	1.50%	57.54%
DartlingGunner, MonkeyVillage, SuperMonkey	61	42	19	68.85%	1.07%	57.23%
IceMonkey, MonkeyVillage, NinjaMonkey	50	32	18	64.00%	0.87%	50.70%
BananaFarm, BoomerangMonkey, NinjaMonkey	221	121	100	54.75%	3.86%	48.19%
BananaFarm, NinjaMonkey, WizardMonkey	92	53	39	57.61%	1.61%	47.51%
BananaFarm, TackShooter, WizardMonkey	295	156	139	52.88%	5.15%	47.19%
BananaFarm, BoomerangMonkey, EngineerMonkey	69	39	30	56.52%	1.21%	44.82%
GlueGunner, MonkeyVillage, TackShooter	169	87	82	51.48%	2.95%	43.94%
DartMonkey, GlueGunner, MonkeyVillage	35	21	14	60.00%	0.61%	43.77%
BananaFarm, BoomerangMonkey, SpikeFactory	125	65	60	52.00%	2.18%	43.24%
BananaFarm, IceMonkey, NinjaMonkey	60	33	27	55.00%	1.05%	42.41%
GlueGunner, MonkeyVillage, NinjaMonkey	35	20	15	57.14%	0.61%	40.75%
IceMonkey, SniperMonkey, SuperMonkey	24	14	10	58.33%	0.42%	38.61%
BananaFarm, DartlingGunner, NinjaMonkey	48	25	23	52.08%	0.84%	37.95%
GlueGunner, HeliPilot, MonkeyVillage	87	42	45	48.28%	1.52%	37.78%
NinjaMonkey, TackShooter, WizardMonkey	42	22	20	52.38%	0.73%	37.28%
BananaFarm, EngineerMonkey, WizardMonkey	23	13	10	56.52%	0.40%	36.26%
SniperMonkey, TackShooter, WizardMonkey	44	22	22	50.00%	0.77%	35.23%
Alchemist, BananaFarm, NinjaMonkey	69	32	37	46.38%	1.21%	34.61%
BananaFarm, BoomerangMonkey, WizardMonkey	62	29	33	46.77%	1.08%	34.35%
BoomerangMonkey, SniperMonkey, WizardMonkey	24	13	11	54.17%	0.42%	34.23%
BananaFarm, DartlingGunner, IceMonkey	41	20	21	48.78%	0.72%	33.48%
EngineerMonkey, MonkeyAce, MonkeyVillage	54	25	29	46.30%	0.94%	33.00%
BananaFarm, BombShooter, MonkeySub	45	21	24	46.67%	0.79%	32.09%
BananaFarm, EngineerMonkey, SpikeFactory	23	12	11	52.17%	0.40%	31.76%
BananaFarm, MonkeySub, TackShooter	38	18	20	47.37%	0.66%	31.49%
HeliPilot, IceMonkey, MonkeyVillage	64	27	37	42.19%	1.12%	30.09%
BananaFarm, SniperMonkey, TackShooter	64	26	38	40.63%	1.12%	28.59%
BananaFarm, SniperMonkey, WizardMonkey	64	26	38	40.63%	1.12%	28.59%
EngineerMonkey, TackShooter, WizardMonkey	36	16	20	44.44%	0.63%	28.21%
BananaFarm, BoomerangMonkey, SuperMonkey	28	13	15	46.43%	0.49%	27.96%
Alchemist, HeliPilot, NinjaMonkey	31	14	17	45.16%	0.54%	27.64%
Alchemist, GlueGunner, NinjaMonkey	34	15	19	44.12%	0.59%	27.43%
BananaFarm, DartMonkey, GlueGunner	23	11	12	47.83%	0.40%	27.41%
BananaFarm, MortarMonkey, TackShooter	24	11	13	45.83%	0.42%	25.90%
BananaFarm, BoomerangMonkey, MonkeySub	22	10	12	45.45%	0.38%	24.65%
BananaFarm, Druid, MonkeySub	53	19	34	35.85%	0.93%	22.94%
SniperMonkey, SpikeFactory, TackShooter	25	10	15	40.00%	0.44%	20.80%
BananaFarm, BombShooter, SpikeFactory	42	14	28	33.33%	0.73%	19.08%
Alchemist, IceMonkey, NinjaMonkey	30	10	20	33.33%	0.52%	16.46%

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)

42 rows

Advanced export