season_25_matches: bloonstone_quarry

65 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, DartMonkey, MortarMonkey	96	71	25	73.96%	1.39%	65.18%
DartlingGunner, Druid, SpikeFactory	74	53	21	71.62%	1.07%	61.35%
Alchemist, MonkeyBuccaneer, SpikeFactory	664	398	266	59.94%	9.61%	56.21%
BananaFarm, IceMonkey, MonkeyBuccaneer	40	28	12	70.00%	0.58%	55.80%
BananaFarm, BombShooter, MonkeySub	74	49	25	66.22%	1.07%	55.44%
Alchemist, IceMonkey, NinjaMonkey	86	54	32	62.79%	1.24%	52.57%
BoomerangMonkey, MortarMonkey, SpikeFactory	40	26	14	65.00%	0.58%	50.22%
DartlingGunner, IceMonkey, MonkeyVillage	57	35	22	61.40%	0.82%	48.77%
BananaFarm, BoomerangMonkey, SniperMonkey	38	24	14	63.16%	0.55%	47.82%
IceMonkey, MonkeyVillage, SuperMonkey	61	36	25	59.02%	0.88%	46.67%
DartlingGunner, Druid, MonkeyVillage	71	41	30	57.75%	1.03%	46.26%
BananaFarm, MonkeySub, SuperMonkey	43	26	17	60.47%	0.62%	45.85%
BananaFarm, BombShooter, SpikeFactory	95	53	42	55.79%	1.37%	45.80%
BananaFarm, DartMonkey, GlueGunner	32	20	12	62.50%	0.46%	45.73%
BananaFarm, SniperMonkey, TackShooter	50	29	21	58.00%	0.72%	44.32%
BananaFarm, BoomerangMonkey, SpikeFactory	52	30	22	57.69%	0.75%	44.26%
DartMonkey, GlueGunner, MonkeyVillage	88	47	41	53.41%	1.27%	42.99%
GlueGunner, HeliPilot, MonkeyVillage	70	38	32	54.29%	1.01%	42.62%
DartMonkey, IceMonkey, MonkeyVillage	93	49	44	52.69%	1.35%	42.54%
BombShooter, MonkeySub, SpikeFactory	34	20	14	58.82%	0.49%	42.28%
BananaFarm, BombShooter, DartlingGunner	48	27	21	56.25%	0.69%	42.22%
HeliPilot, IceMonkey, SuperMonkey	75	40	35	53.33%	1.09%	42.04%
DartlingGunner, MonkeyVillage, SuperMonkey	148	74	74	50.00%	2.14%	41.94%
BananaFarm, DartMonkey, SpikeFactory	37	21	16	56.76%	0.54%	40.79%
SniperMonkey, SpikeFactory, TackShooter	37	21	16	56.76%	0.54%	40.79%
BananaFarm, GlueGunner, MonkeySub	31	18	13	58.06%	0.45%	40.69%
BananaFarm, Druid, MonkeySub	78	40	38	51.28%	1.13%	40.19%
BananaFarm, TackShooter, WizardMonkey	50	27	23	54.00%	0.72%	40.19%
BananaFarm, DartlingGunner, IceMonkey	42	23	19	54.76%	0.61%	39.71%
GlueGunner, MonkeyVillage, NinjaMonkey	135	64	71	47.41%	1.95%	38.98%
BananaFarm, DartMonkey, MonkeySub	31	17	14	54.84%	0.45%	37.32%
SniperMonkey, SuperMonkey, TackShooter	31	17	14	54.84%	0.45%	37.32%
GlueGunner, MonkeyVillage, TackShooter	101	46	55	45.54%	1.46%	35.83%
MonkeyVillage, SniperMonkey, SuperMonkey	26	14	12	53.85%	0.38%	34.68%
Alchemist, DartlingGunner, SpikeFactory	33	17	16	51.52%	0.48%	34.46%
BananaFarm, SniperMonkey, WizardMonkey	29	15	14	51.72%	0.42%	33.54%
Alchemist, GlueGunner, NinjaMonkey	39	19	20	48.72%	0.56%	33.03%
Alchemist, NinjaMonkey, SniperMonkey	27	14	13	51.85%	0.39%	33.00%
MonkeyBuccaneer, SniperMonkey, WizardMonkey	32	16	16	50.00%	0.46%	32.68%
IceMonkey, MonkeyVillage, TackShooter	143	58	85	40.56%	2.07%	32.51%
BananaFarm, GlueGunner, MonkeyBuccaneer	25	13	12	52.00%	0.36%	32.42%
SniperMonkey, SpikeFactory, WizardMonkey	35	17	18	48.57%	0.51%	32.01%
BananaFarm, BombShooter, WizardMonkey	33	16	17	48.48%	0.48%	31.43%
DartMonkey, SniperMonkey, SuperMonkey	21	11	10	52.38%	0.30%	31.02%
BombShooter, HeliPilot, WizardMonkey	31	15	16	48.39%	0.45%	30.79%
Alchemist, MonkeySub, SpikeFactory	29	14	15	48.28%	0.42%	30.09%
BananaFarm, MonkeyBuccaneer, WizardMonkey	24	12	12	50.00%	0.35%	30.00%
IceMonkey, MonkeyVillage, NinjaMonkey	30	14	16	46.67%	0.43%	28.81%
SniperMonkey, SuperMonkey, WizardMonkey	41	18	23	43.90%	0.59%	28.71%
SniperMonkey, SpikeFactory, SuperMonkey	42	18	24	42.86%	0.61%	27.89%

Advanced export

JSON shape: default, array, newline-delimited

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

bloonstone_quarry_loadouts (view)

65 rows

Advanced export