season_31_matches: off_tide

38 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	120	86	34	71.67%	1.90%	63.60%
BananaFarm, EngineerMonkey, WizardMonkey	50	37	13	74.00%	0.79%	61.84%
BananaFarm, IceMonkey, NinjaMonkey	56	41	15	73.21%	0.89%	61.62%
BananaFarm, DartlingGunner, IceMonkey	265	176	89	66.42%	4.19%	60.73%
BananaFarm, BoomerangMonkey, IceMonkey	39	27	12	69.23%	0.62%	54.75%
BananaFarm, TackShooter, WizardMonkey	1513	850	663	56.18%	23.92%	53.68%
BananaFarm, BoomerangMonkey, SpikeFactory	132	81	51	61.36%	2.09%	53.06%
BananaFarm, DartlingGunner, NinjaMonkey	107	64	43	59.81%	1.69%	50.52%
DartlingGunner, MonkeyVillage, SuperMonkey	139	81	58	58.27%	2.20%	50.08%
BananaFarm, BoomerangMonkey, NinjaMonkey	138	76	62	55.07%	2.18%	46.77%
BananaFarm, BoomerangMonkey, WizardMonkey	81	46	35	56.79%	1.28%	46.00%
BananaFarm, BombShooter, WizardMonkey	82	46	36	56.10%	1.30%	45.36%
BananaFarm, DartMonkey, GlueGunner	27	17	10	62.96%	0.43%	44.75%
BananaFarm, HeliPilot, IceMonkey	78	43	35	55.13%	1.23%	44.09%
BananaFarm, BoomerangMonkey, EngineerMonkey	43	25	18	58.14%	0.68%	43.39%
BananaFarm, BombShooter, TackShooter	30	18	12	60.00%	0.47%	42.47%
BananaFarm, SniperMonkey, TackShooter	56	31	25	55.36%	0.89%	42.34%
BoomerangMonkey, MonkeyVillage, SuperMonkey	30	17	13	56.67%	0.47%	38.93%
SniperMonkey, SpikeFactory, WizardMonkey	26	15	11	57.69%	0.41%	38.70%
BananaFarm, MortarMonkey, TackShooter	159	73	86	45.91%	2.51%	38.17%
BananaFarm, SniperMonkey, WizardMonkey	67	33	34	49.25%	1.06%	37.28%
DartlingGunner, Druid, SpikeFactory	27	15	12	55.56%	0.43%	36.81%
SniperMonkey, SpikeFactory, TackShooter	25	14	11	56.00%	0.40%	36.54%
IceMonkey, MonkeyVillage, NinjaMonkey	50	25	25	50.00%	0.79%	36.14%
EngineerMonkey, TackShooter, WizardMonkey	30	16	14	53.33%	0.47%	35.48%
HeliPilot, IceMonkey, MonkeyVillage	59	28	31	47.46%	0.93%	34.72%
Alchemist, BananaFarm, NinjaMonkey	47	23	24	48.94%	0.74%	34.64%
BananaFarm, BombShooter, SpikeFactory	58	26	32	44.83%	0.92%	32.03%
BananaFarm, BoomerangMonkey, SniperMonkey	31	15	16	48.39%	0.49%	30.79%
BananaFarm, DartlingGunner, SuperMonkey	61	26	35	42.62%	0.96%	30.21%
BananaFarm, DartMonkey, SpikeFactory	35	16	19	45.71%	0.55%	29.21%
GlueGunner, MonkeyVillage, TackShooter	158	57	101	36.08%	2.50%	28.59%
BananaFarm, NinjaMonkey, WizardMonkey	56	23	33	41.07%	0.89%	28.19%
BananaFarm, BoomerangMonkey, DartlingGunner	24	11	13	45.83%	0.38%	25.90%
DartlingGunner, IceMonkey, MonkeyVillage	27	12	15	44.44%	0.43%	25.70%
BananaFarm, EngineerMonkey, MonkeyAce	59	21	38	35.59%	0.93%	23.38%
BananaFarm, GlueGunner, TackShooter	35	13	22	37.14%	0.55%	21.13%
BananaFarm, NinjaMonkey, TackShooter	29	10	19	34.48%	0.46%	17.18%

Advanced export

JSON shape: default, array, newline-delimited

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

off_tide_loadouts (view)

38 rows

Advanced export