s24+_matches: bloonstone_quarry

338 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
Alchemist, DartMonkey, SpikeFactory	125	96	29	76.80%	0.24%	69.40%
BananaFarm, DartMonkey, MortarMonkey	394	277	117	70.30%	0.76%	65.79%
BananaFarm, BombShooter, MonkeySub	930	601	329	64.62%	1.79%	61.55%
Alchemist, MonkeyBuccaneer, SpikeFactory	4151	2529	1622	60.93%	7.99%	59.44%
HeliPilot, IceMonkey, SuperMonkey	700	438	262	62.57%	1.35%	58.99%
BananaFarm, Druid, MortarMonkey	37	27	10	72.97%	0.07%	58.66%
BananaFarm, IceMonkey, MonkeySub	2707	1637	1070	60.47%	5.21%	58.63%
BananaFarm, DartlingGunner, IceMonkey	607	374	233	61.61%	1.17%	57.75%
BananaFarm, BoomerangMonkey, MortarMonkey	192	123	69	64.06%	0.37%	57.28%
DartlingGunner, Druid, SpikeFactory	185	118	67	63.78%	0.36%	56.86%
IceMonkey, MonkeyVillage, NinjaMonkey	307	191	116	62.21%	0.59%	56.79%
BombShooter, MonkeyVillage, WizardMonkey	85	56	29	65.88%	0.16%	55.80%
BombShooter, MonkeySub, SpikeFactory	302	185	117	61.26%	0.58%	55.76%
BananaFarm, BombShooter, GlueGunner	37	26	11	70.27%	0.07%	55.54%
IceMonkey, MonkeyBuccaneer, MonkeyVillage	79	52	27	65.82%	0.15%	55.36%
BoomerangMonkey, MonkeyVillage, SpikeFactory	129	82	47	63.57%	0.25%	55.26%
BananaFarm, BoomerangMonkey, MonkeySub	294	178	116	60.54%	0.57%	54.96%
BananaFarm, BombShooter, MortarMonkey	55	37	18	67.27%	0.11%	54.87%
DartMonkey, MonkeyBuccaneer, TackShooter	46	31	15	67.39%	0.09%	53.84%
DartMonkey, NinjaMonkey, SniperMonkey	58	38	20	65.52%	0.11%	53.28%
BananaFarm, BombShooter, WizardMonkey	312	182	130	58.33%	0.60%	52.86%
BananaFarm, Druid, MonkeySub	922	512	410	55.53%	1.77%	52.32%
IceMonkey, MonkeyBuccaneer, SuperMonkey	92	57	35	61.96%	0.18%	52.04%
BananaFarm, IceMonkey, MonkeyBuccaneer	158	94	64	59.49%	0.30%	51.84%
BananaFarm, BombShooter, SniperMonkey	110	67	43	60.91%	0.21%	51.79%
DartlingGunner, IceMonkey, MonkeyVillage	313	179	134	57.19%	0.60%	51.71%
BananaFarm, DartMonkey, MonkeySub	217	126	91	58.06%	0.42%	51.50%
BananaFarm, DartMonkey, SniperMonkey	79	49	30	62.03%	0.15%	51.32%
Alchemist, IceMonkey, NinjaMonkey	466	258	208	55.36%	0.90%	50.85%
IceMonkey, MonkeyBuccaneer, SpikeFactory	50	32	18	64.00%	0.10%	50.70%
BombShooter, MonkeyBuccaneer, SpikeFactory	45	29	16	64.44%	0.09%	50.46%
BoomerangMonkey, MortarMonkey, SpikeFactory	168	97	71	57.74%	0.32%	50.27%
DartMonkey, MonkeyVillage, SuperMonkey	150	87	63	58.00%	0.29%	50.10%
BananaFarm, BoomerangMonkey, EngineerMonkey	54	34	20	62.96%	0.10%	50.08%
DartMonkey, SpikeFactory, WizardMonkey	63	39	24	61.90%	0.12%	49.91%
BananaFarm, DartMonkey, NinjaMonkey	30	20	10	66.67%	0.06%	49.80%
DartlingGunner, Druid, MonkeyVillage	298	165	133	55.37%	0.57%	49.72%
BananaFarm, BoomerangMonkey, NinjaMonkey	239	133	106	55.65%	0.46%	49.35%
DartlingGunner, MonkeyVillage, SuperMonkey	1648	852	796	51.70%	3.17%	49.29%
BananaFarm, BombShooter, SpikeFactory	476	253	223	53.15%	0.92%	48.67%
BananaFarm, EngineerMonkey, MonkeySub	68	41	27	60.29%	0.13%	48.66%
Druid, IceMonkey, NinjaMonkey	68	41	27	60.29%	0.13%	48.66%
GlueGunner, HeliPilot, MonkeySub	72	43	29	59.72%	0.14%	48.39%
BananaFarm, HeliPilot, IceMonkey	74	44	30	59.46%	0.14%	48.27%
DartMonkey, GlueGunner, MonkeyVillage	488	257	231	52.66%	0.94%	48.23%
BananaFarm, GlueGunner, MonkeySub	146	82	64	56.16%	0.28%	48.12%
BananaFarm, BoomerangMonkey, SniperMonkey	195	107	88	54.87%	0.38%	47.89%
BananaFarm, DartMonkey, WizardMonkey	124	70	54	56.45%	0.24%	47.72%
DartMonkey, IceMonkey, MonkeyVillage	292	156	136	53.42%	0.56%	47.70%
IceMonkey, MonkeyVillage, TackShooter	929	472	457	50.81%	1.79%	47.59%

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)

338 rows

Advanced export