season_31_matches: garden_loadouts: 28 rows

28 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, WizardMonkey	89	63	26	70.79%	2.81%	61.34%
DartlingGunner, MonkeyVillage, SuperMonkey	74	51	23	68.92%	2.34%	58.37%
BananaFarm, BoomerangMonkey, WizardMonkey	58	39	19	67.24%	1.83%	55.16%
BananaFarm, DartMonkey, SniperMonkey	72	47	25	65.28%	2.27%	54.28%
BananaFarm, DartlingGunner, IceMonkey	35	24	11	68.57%	1.10%	53.19%
BananaFarm, DartlingGunner, NinjaMonkey	76	48	28	63.16%	2.40%	52.31%
BananaFarm, Druid, MonkeySub	64	41	23	64.06%	2.02%	52.31%
DartMonkey, NinjaMonkey, SniperMonkey	164	95	69	57.93%	5.18%	50.37%
BananaFarm, DartMonkey, MortarMonkey	57	35	22	61.40%	1.80%	48.77%
BananaFarm, DartlingGunner, WizardMonkey	30	19	11	63.33%	0.95%	46.09%
DartMonkey, GlueGunner, SniperMonkey	38	22	16	57.89%	1.20%	42.20%
DartMonkey, SniperMonkey, SpikeFactory	42	24	18	57.14%	1.33%	42.18%
BananaFarm, DartMonkey, SpikeFactory	128	65	63	50.78%	4.04%	42.12%
BananaFarm, DartMonkey, WizardMonkey	37	21	16	56.76%	1.17%	40.79%
Alchemist, BananaFarm, DartlingGunner	27	16	11	59.26%	0.85%	40.73%
BananaFarm, DartMonkey, NinjaMonkey	31	18	13	58.06%	0.98%	40.69%
DartMonkey, GlueGunner, MonkeyVillage	86	42	44	48.84%	2.71%	38.27%
BananaFarm, BombShooter, MonkeySub	35	19	16	54.29%	1.10%	37.78%
BananaFarm, DartMonkey, MonkeySub	69	33	36	47.83%	2.18%	36.04%
BananaFarm, BoomerangMonkey, NinjaMonkey	62	29	33	46.77%	1.96%	34.35%
BananaFarm, TackShooter, WizardMonkey	78	35	43	44.87%	2.46%	33.83%
BananaFarm, BoomerangMonkey, EngineerMonkey	25	13	12	52.00%	0.79%	32.42%
BananaFarm, SniperMonkey, TackShooter	20	10	10	50.00%	0.63%	28.09%
BananaFarm, SniperMonkey, WizardMonkey	39	17	22	43.59%	1.23%	28.03%
Alchemist, MonkeyBuccaneer, SpikeFactory	35	15	20	42.86%	1.10%	26.46%
BananaFarm, IceMonkey, MonkeySub	48	19	29	39.58%	1.52%	25.75%
BananaFarm, BoomerangMonkey, SpikeFactory	31	13	18	41.94%	0.98%	24.56%
BananaFarm, DartMonkey, EngineerMonkey	30	10	20	33.33%	0.95%	16.46%

Advanced export

JSON shape: default, array, newline-delimited

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

garden_loadouts (view)

28 rows

Advanced export