season_27_matches: precious_space

29 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	88	67	21	76.14%	2.26%	67.23%
BananaFarm, BombShooter, MonkeySub	340	235	105	69.12%	8.74%	64.21%
Alchemist, MonkeyBuccaneer, SpikeFactory	116	73	43	62.93%	2.98%	54.14%
BananaFarm, BombShooter, WizardMonkey	37	25	12	67.57%	0.95%	52.48%
BananaFarm, Druid, MonkeySub	320	177	143	55.31%	8.22%	49.87%
BananaFarm, DartMonkey, MortarMonkey	27	17	10	62.96%	0.69%	44.75%
BananaFarm, MonkeyAce, MonkeySub	27	17	10	62.96%	0.69%	44.75%
Alchemist, DartlingGunner, SpikeFactory	117	62	55	52.99%	3.01%	43.95%
BananaFarm, DartlingGunner, SpikeFactory	28	17	11	60.71%	0.72%	42.62%
DartlingGunner, MonkeyVillage, SuperMonkey	110	57	53	51.82%	2.83%	42.48%
BananaFarm, MonkeySub, SuperMonkey	29	17	12	58.62%	0.75%	40.70%
BananaFarm, DartlingGunner, NinjaMonkey	24	14	10	58.33%	0.62%	38.61%
BananaFarm, DartlingGunner, IceMonkey	29	16	13	55.17%	0.75%	37.07%
Druid, MonkeySub, SpikeFactory	48	24	24	50.00%	1.23%	35.85%
DartlingGunner, SniperMonkey, SpikeFactory	25	13	12	52.00%	0.64%	32.42%
BananaFarm, SniperMonkey, WizardMonkey	35	17	18	48.57%	0.90%	32.01%
BananaFarm, TackShooter, WizardMonkey	61	27	34	44.26%	1.57%	31.80%
SniperMonkey, TackShooter, WizardMonkey	23	12	11	52.17%	0.59%	31.76%
BananaFarm, DartlingGunner, SuperMonkey	120	47	73	39.17%	3.08%	30.43%
BananaFarm, BoomerangMonkey, MonkeySub	35	15	20	42.86%	0.90%	26.46%
BananaFarm, BoomerangMonkey, SpikeFactory	49	18	31	36.73%	1.26%	23.24%
DartlingGunner, SpikeFactory, SuperMonkey	23	10	13	43.48%	0.59%	23.22%
SniperMonkey, SuperMonkey, WizardMonkey	23	10	13	43.48%	0.59%	23.22%
Alchemist, GlueGunner, NinjaMonkey	27	11	16	40.74%	0.69%	22.21%
GlueGunner, HeliPilot, MonkeySub	28	11	17	39.29%	0.72%	21.20%
DartMonkey, GlueGunner, MonkeyVillage	32	12	20	37.50%	0.82%	20.73%
GlueGunner, HeliPilot, MonkeyVillage	32	12	20	37.50%	0.82%	20.73%
BoomerangMonkey, MortarMonkey, SpikeFactory	33	11	22	33.33%	0.85%	17.25%
Alchemist, BananaFarm, NinjaMonkey	33	10	23	30.30%	0.85%	14.62%

Advanced export

JSON shape: default, array, newline-delimited

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

precious_space_loadouts (view)

29 rows

Advanced export