season_29_matches: garden_loadouts: 35 rows

35 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, DartMonkey, MortarMonkey	123	90	33	73.17%	3.43%	65.34%
BananaFarm, BoomerangMonkey, MortarMonkey	81	60	21	74.07%	2.26%	64.53%
BananaFarm, EngineerMonkey, MonkeyAce	49	36	13	73.47%	1.37%	61.11%
DartMonkey, NinjaMonkey, SniperMonkey	126	80	46	63.49%	3.51%	55.09%
BananaFarm, DartMonkey, MonkeySub	132	80	52	60.61%	3.68%	52.27%
BananaFarm, Druid, MonkeySub	183	107	76	58.47%	5.10%	51.33%
BananaFarm, DartMonkey, WizardMonkey	36	23	13	63.89%	1.00%	48.20%
DartMonkey, GlueGunner, MonkeyVillage	112	63	49	56.25%	3.12%	47.06%
Alchemist, MonkeyBuccaneer, SpikeFactory	34	21	13	61.76%	0.95%	45.43%
BananaFarm, DartMonkey, SniperMonkey	58	33	25	56.90%	1.62%	44.15%
BananaFarm, DartMonkey, SpikeFactory	74	40	34	54.05%	2.06%	42.70%
GlueGunner, MonkeyVillage, TackShooter	32	19	13	59.38%	0.89%	42.36%
DartlingGunner, MonkeyVillage, SuperMonkey	46	26	20	56.52%	1.28%	42.20%
BananaFarm, BoomerangMonkey, EngineerMonkey	27	16	11	59.26%	0.75%	40.73%
BananaFarm, DartMonkey, IceMonkey	31	18	13	58.06%	0.86%	40.69%
BananaFarm, BombShooter, MonkeySub	53	28	25	52.83%	1.48%	39.39%
BananaFarm, DartMonkey, EngineerMonkey	28	16	12	57.14%	0.78%	38.81%
DartMonkey, SniperMonkey, SuperMonkey	24	14	10	58.33%	0.67%	38.61%
BananaFarm, DartlingGunner, IceMonkey	39	21	18	53.85%	1.09%	38.20%
BananaFarm, IceMonkey, MonkeySub	222	99	123	44.59%	6.19%	38.06%
DartMonkey, GlueGunner, MonkeySub	33	18	15	54.55%	0.92%	37.56%
BananaFarm, MonkeySub, WizardMonkey	23	13	10	56.52%	0.64%	36.26%
BananaFarm, DartlingGunner, NinjaMonkey	38	19	19	50.00%	1.06%	34.10%
BananaFarm, BoomerangMonkey, SpikeFactory	54	24	30	44.44%	1.51%	31.19%
DartMonkey, MonkeyVillage, SniperMonkey	21	11	10	52.38%	0.59%	31.02%
BananaFarm, BoomerangMonkey, NinjaMonkey	47	20	27	42.55%	1.31%	28.42%
BananaFarm, DartMonkey, NinjaMonkey	39	17	22	43.59%	1.09%	28.03%
BananaFarm, SniperMonkey, WizardMonkey	34	15	19	44.12%	0.95%	27.43%
BananaFarm, TackShooter, WizardMonkey	71	26	45	36.62%	1.98%	25.41%
BananaFarm, DartMonkey, GlueGunner	52	20	32	38.46%	1.45%	25.24%
DartMonkey, GlueGunner, SniperMonkey	25	11	14	44.00%	0.70%	24.54%
DartMonkey, MonkeySub, NinjaMonkey	25	11	14	44.00%	0.70%	24.54%
EngineerMonkey, TackShooter, WizardMonkey	25	11	14	44.00%	0.70%	24.54%
BananaFarm, MonkeySub, TackShooter	36	14	22	38.89%	1.00%	22.96%
BananaFarm, NinjaMonkey, WizardMonkey	34	11	23	32.35%	0.95%	16.63%

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)

35 rows

Advanced export