season_30_matches: off_tide

43 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	172	114	58	66.28%	2.96%	59.21%
BananaFarm, DartlingGunner, IceMonkey	383	244	139	63.71%	6.59%	58.89%
BananaFarm, BoomerangMonkey, MortarMonkey	117	78	39	66.67%	2.01%	58.12%
BananaFarm, MortarMonkey, TackShooter	150	94	56	62.67%	2.58%	54.93%
BananaFarm, TackShooter, WizardMonkey	729	407	322	55.83%	12.55%	52.23%
BananaFarm, BoomerangMonkey, SpikeFactory	200	116	84	58.00%	3.44%	51.16%
DartlingGunner, MonkeyVillage, SuperMonkey	111	66	45	59.46%	1.91%	50.33%
BananaFarm, BoomerangMonkey, NinjaMonkey	207	117	90	56.52%	3.56%	49.77%
BananaFarm, DartlingGunner, NinjaMonkey	72	43	29	59.72%	1.24%	48.39%
BananaFarm, BombShooter, SpikeFactory	52	31	21	59.62%	0.90%	46.28%
BananaFarm, NinjaMonkey, WizardMonkey	89	50	39	56.18%	1.53%	45.87%
BananaFarm, HeliPilot, IceMonkey	37	22	15	59.46%	0.64%	43.64%
BananaFarm, BombShooter, WizardMonkey	119	62	57	52.10%	2.05%	43.13%
GlueGunner, MonkeyVillage, TackShooter	207	102	105	49.28%	3.56%	42.46%
BananaFarm, GlueGunner, TackShooter	43	24	19	55.81%	0.74%	40.97%
BananaFarm, BoomerangMonkey, IceMonkey	44	24	20	54.55%	0.76%	39.83%
BananaFarm, IceMonkey, WizardMonkey	32	18	14	56.25%	0.55%	39.06%
BananaFarm, DartMonkey, SpikeFactory	24	14	10	58.33%	0.41%	38.61%
BananaFarm, BoomerangMonkey, EngineerMonkey	70	34	36	48.57%	1.21%	36.86%
BananaFarm, IceMonkey, NinjaMonkey	68	33	35	48.53%	1.17%	36.65%
IceMonkey, MonkeyVillage, NinjaMonkey	23	13	10	56.52%	0.40%	36.26%
SpikeFactory, TackShooter, WizardMonkey	23	13	10	56.52%	0.40%	36.26%
BananaFarm, SniperMonkey, WizardMonkey	72	32	40	44.44%	1.24%	32.97%
Alchemist, BananaFarm, NinjaMonkey	52	24	28	46.15%	0.90%	32.60%
IceMonkey, SniperMonkey, SuperMonkey	23	12	11	52.17%	0.40%	31.76%
HeliPilot, IceMonkey, MonkeyVillage	54	24	30	44.44%	0.93%	31.19%
BananaFarm, BoomerangMonkey, WizardMonkey	34	16	18	47.06%	0.59%	30.28%
EngineerMonkey, TackShooter, WizardMonkey	29	14	15	48.28%	0.50%	30.09%
BananaFarm, SniperMonkey, TackShooter	62	26	36	41.94%	1.07%	29.65%
BananaFarm, NinjaMonkey, TackShooter	32	15	17	46.88%	0.55%	29.58%
Alchemist, IceMonkey, NinjaMonkey	27	13	14	48.15%	0.46%	29.30%
BananaFarm, Druid, MonkeySub	41	18	23	43.90%	0.71%	28.71%
BananaFarm, DartMonkey, MortarMonkey	33	15	18	45.45%	0.57%	28.47%
GlueGunner, SniperMonkey, WizardMonkey	20	10	10	50.00%	0.34%	28.09%
SniperMonkey, TackShooter, WizardMonkey	40	17	23	42.50%	0.69%	27.18%
BananaFarm, DartlingGunner, GlueGunner	21	10	11	47.62%	0.36%	26.26%
BoomerangMonkey, NinjaMonkey, SniperMonkey	22	10	12	45.45%	0.38%	24.65%
BananaFarm, DartlingGunner, WizardMonkey	25	11	14	44.00%	0.43%	24.54%
BananaFarm, MonkeySub, TackShooter	23	10	13	43.48%	0.40%	23.22%
BananaFarm, DartlingGunner, SuperMonkey	25	10	15	40.00%	0.43%	20.80%
BananaFarm, IceMonkey, SuperMonkey	35	11	24	31.43%	0.60%	16.05%
BananaFarm, IceMonkey, MonkeySub	54	15	39	27.78%	0.93%	15.83%
SniperMonkey, SpikeFactory, TackShooter	33	10	23	30.30%	0.57%	14.62%

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)

43 rows

Advanced export