season_28_matches: off_tide

44 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	93	64	29	68.82%	1.34%	59.40%
BananaFarm, BoomerangMonkey, IceMonkey	81	56	25	69.14%	1.17%	59.08%
BananaFarm, MortarMonkey, TackShooter	361	227	134	62.88%	5.22%	57.90%
BananaFarm, BombShooter, WizardMonkey	197	124	73	62.94%	2.85%	56.20%
BananaFarm, DartMonkey, GlueGunner	175	110	65	62.86%	2.53%	55.70%
BananaFarm, DartMonkey, WizardMonkey	39	27	12	69.23%	0.56%	54.75%
BananaFarm, BoomerangMonkey, NinjaMonkey	329	196	133	59.57%	4.76%	54.27%
BananaFarm, DartMonkey, MortarMonkey	84	54	30	64.29%	1.21%	54.04%
BananaFarm, BoomerangMonkey, MonkeyAce	43	28	15	65.12%	0.62%	50.87%
BananaFarm, BoomerangMonkey, SpikeFactory	315	176	139	55.87%	4.55%	50.39%
BananaFarm, DartlingGunner, IceMonkey	85	51	34	60.00%	1.23%	49.59%
BananaFarm, EngineerMonkey, MonkeyAce	181	101	80	55.80%	2.62%	48.57%
DartlingGunner, MonkeyVillage, SuperMonkey	59	36	23	61.02%	0.85%	48.57%
BananaFarm, BoomerangMonkey, WizardMonkey	29	19	10	65.52%	0.42%	48.22%
BananaFarm, TackShooter, WizardMonkey	684	351	333	51.32%	9.89%	47.57%
BananaFarm, IceMonkey, WizardMonkey	75	44	31	58.67%	1.08%	47.52%
HeliPilot, IceMonkey, SuperMonkey	42	26	16	61.90%	0.61%	47.22%
DartMonkey, GlueGunner, MonkeyVillage	45	27	18	60.00%	0.65%	45.69%
BananaFarm, BoomerangMonkey, EngineerMonkey	142	76	66	53.52%	2.05%	45.32%
DartlingGunner, SpikeFactory, SuperMonkey	29	18	11	62.07%	0.42%	44.41%
BananaFarm, BombShooter, MortarMonkey	70	38	32	54.29%	1.01%	42.62%
BananaFarm, GlueGunner, TackShooter	81	42	39	51.85%	1.17%	40.97%
BananaFarm, BoomerangMonkey, GlueGunner	31	18	13	58.06%	0.45%	40.69%
BananaFarm, SniperMonkey, TackShooter	55	29	26	52.73%	0.80%	39.53%
BananaFarm, DartMonkey, SpikeFactory	52	27	25	51.92%	0.75%	38.34%
BananaFarm, BombShooter, SpikeFactory	162	73	89	45.06%	2.34%	37.40%
BananaFarm, BombShooter, MonkeySub	60	30	30	50.00%	0.87%	37.35%
BananaFarm, NinjaMonkey, WizardMonkey	67	33	34	49.25%	0.97%	37.28%
Alchemist, BananaFarm, NinjaMonkey	76	36	40	47.37%	1.10%	36.14%
GlueGunner, MonkeyVillage, TackShooter	230	97	133	42.17%	3.33%	35.79%
IceMonkey, MonkeyVillage, NinjaMonkey	59	28	31	47.46%	0.85%	34.72%
BananaFarm, SniperMonkey, WizardMonkey	61	28	33	45.90%	0.88%	33.40%
BananaFarm, IceMonkey, TackShooter	51	24	27	47.06%	0.74%	33.36%
IceMonkey, MonkeyVillage, TackShooter	44	21	23	47.73%	0.64%	32.97%
Alchemist, IceMonkey, NinjaMonkey	25	13	12	52.00%	0.36%	32.42%
GlueGunner, HeliPilot, MonkeyVillage	69	30	39	43.48%	1.00%	31.78%
BananaFarm, Druid, MonkeySub	94	39	55	41.49%	1.36%	31.53%
SniperMonkey, TackShooter, WizardMonkey	35	16	19	45.71%	0.51%	29.21%
BananaFarm, IceMonkey, SuperMonkey	37	16	21	43.24%	0.53%	27.28%
BananaFarm, DartlingGunner, SuperMonkey	40	17	23	42.50%	0.58%	27.18%
BombShooter, MonkeyVillage, SpikeFactory	33	14	19	42.42%	0.48%	25.56%
BananaFarm, BoomerangMonkey, SuperMonkey	28	12	16	42.86%	0.40%	24.53%
SpikeFactory, TackShooter, WizardMonkey	32	12	20	37.50%	0.46%	20.73%
BananaFarm, BoomerangMonkey, SniperMonkey	30	11	19	36.67%	0.43%	19.42%

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)

44 rows

Advanced export