season_25_matches: precious_space

32 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	86	65	21	75.58%	2.04%	66.50%
BananaFarm, BombShooter, MonkeySub	276	188	88	68.12%	6.54%	62.62%
BananaFarm, DartMonkey, MortarMonkey	62	45	17	72.58%	1.47%	61.48%
DartlingGunner, Druid, SpikeFactory	43	32	11	74.42%	1.02%	61.38%
BananaFarm, Druid, MonkeySub	228	135	93	59.21%	5.40%	52.83%
Alchemist, MonkeyBuccaneer, SpikeFactory	110	65	45	59.09%	2.61%	49.90%
BananaFarm, BoomerangMonkey, SpikeFactory	124	70	54	56.45%	2.94%	47.72%
BananaFarm, BoomerangMonkey, SniperMonkey	28	18	10	64.29%	0.66%	46.54%
Alchemist, DartlingGunner, SpikeFactory	111	58	53	52.25%	2.63%	42.96%
BananaFarm, BoomerangMonkey, MonkeySub	31	18	13	58.06%	0.73%	40.69%
BananaFarm, TackShooter, WizardMonkey	73	37	36	50.68%	1.73%	39.22%
BananaFarm, SniperMonkey, TackShooter	43	23	20	53.49%	1.02%	38.58%
BananaFarm, BombShooter, SpikeFactory	54	28	26	51.85%	1.28%	38.52%
BananaFarm, MonkeySub, SuperMonkey	29	16	13	55.17%	0.69%	37.07%
DartlingGunner, MonkeyVillage, SuperMonkey	57	28	29	49.12%	1.35%	36.14%
BananaFarm, BombShooter, DartlingGunner	30	16	14	53.33%	0.71%	35.48%
DartlingGunner, SniperMonkey, SuperMonkey	22	12	10	54.55%	0.52%	33.74%
BananaFarm, BombShooter, WizardMonkey	35	17	18	48.57%	0.83%	32.01%
BananaFarm, BoomerangMonkey, NinjaMonkey	28	14	14	50.00%	0.66%	31.48%
BoomerangMonkey, MortarMonkey, SpikeFactory	28	14	14	50.00%	0.66%	31.48%
BananaFarm, DartlingGunner, SuperMonkey	51	23	28	45.10%	1.21%	31.44%
Alchemist, GlueGunner, NinjaMonkey	48	21	27	43.75%	1.14%	29.72%
BombShooter, MonkeyVillage, MortarMonkey	22	11	11	50.00%	0.52%	29.11%
DartlingGunner, GlueGunner, SniperMonkey	20	10	10	50.00%	0.47%	28.09%
Druid, MonkeySub, SpikeFactory	38	16	22	42.11%	0.90%	26.41%
MonkeyBuccaneer, SniperMonkey, TackShooter	22	10	12	45.45%	0.52%	24.65%
SniperMonkey, TackShooter, WizardMonkey	22	10	12	45.45%	0.52%	24.65%
DartMonkey, GlueGunner, MonkeyVillage	27	11	16	40.74%	0.64%	22.21%
DartlingGunner, Druid, MonkeyVillage	24	10	14	41.67%	0.57%	21.94%
BananaFarm, DartMonkey, GlueGunner	27	10	17	37.04%	0.64%	18.82%
BananaFarm, SniperMonkey, WizardMonkey	33	11	22	33.33%	0.78%	17.25%
GlueGunner, MonkeyVillage, NinjaMonkey	56	12	44	21.43%	1.33%	10.68%

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)

32 rows

Advanced export