season_27_matches: bloonstone_quarry

45 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
HeliPilot, IceMonkey, SuperMonkey	180	124	56	68.89%	2.97%	62.13%
Alchemist, MonkeyBuccaneer, SpikeFactory	622	388	234	62.38%	10.26%	58.57%
BananaFarm, DartlingGunner, IceMonkey	116	73	43	62.93%	1.91%	54.14%
BananaFarm, DartMonkey, MonkeySub	43	29	14	67.44%	0.71%	53.44%
BananaFarm, BombShooter, MonkeySub	85	54	31	63.53%	1.40%	53.30%
BananaFarm, DartMonkey, MortarMonkey	49	32	17	65.31%	0.81%	51.98%
Alchemist, IceMonkey, NinjaMonkey	47	30	17	63.83%	0.78%	50.09%
DartlingGunner, MonkeyVillage, SuperMonkey	253	140	113	55.34%	4.17%	49.21%
DartMonkey, GlueGunner, MonkeyVillage	79	47	32	59.49%	1.30%	48.67%
BananaFarm, MonkeySub, SuperMonkey	43	27	16	62.79%	0.71%	48.34%
BananaFarm, BombShooter, WizardMonkey	44	27	17	61.36%	0.73%	46.98%
DartlingGunner, IceMonkey, MonkeyVillage	44	26	18	59.09%	0.73%	44.56%
BananaFarm, BoomerangMonkey, SpikeFactory	33	20	13	60.61%	0.54%	43.93%
IceMonkey, NinjaMonkey, SniperMonkey	28	17	11	60.71%	0.46%	42.62%
BananaFarm, DartMonkey, GlueGunner	30	18	12	60.00%	0.49%	42.47%
GlueGunner, HeliPilot, MonkeyVillage	89	47	42	52.81%	1.47%	42.44%
DartMonkey, IceMonkey, MonkeyVillage	36	21	15	58.33%	0.59%	42.23%
IceMonkey, MonkeyVillage, TackShooter	145	73	72	50.34%	2.39%	42.21%
SpikeFactory, TackShooter, WizardMonkey	39	22	17	56.41%	0.64%	40.85%
GlueGunner, MonkeyVillage, TackShooter	158	76	82	48.10%	2.61%	40.31%
Alchemist, DartlingGunner, SpikeFactory	44	24	20	54.55%	0.73%	39.83%
BananaFarm, BoomerangMonkey, MonkeySub	26	15	11	57.69%	0.43%	38.70%
IceMonkey, MonkeyVillage, SuperMonkey	64	32	32	50.00%	1.06%	37.75%
BananaFarm, IceMonkey, SuperMonkey	83	40	43	48.19%	1.37%	37.44%
BananaFarm, BombShooter, SpikeFactory	49	25	24	51.02%	0.81%	37.02%
BananaFarm, Druid, MonkeySub	87	41	46	47.13%	1.44%	36.64%
BoomerangMonkey, MortarMonkey, SpikeFactory	23	13	10	56.52%	0.38%	36.26%
BananaFarm, DartlingGunner, SpikeFactory	32	17	15	53.13%	0.53%	35.83%
MonkeyBuccaneer, SniperMonkey, WizardMonkey	28	15	13	53.57%	0.46%	35.10%
BananaFarm, SniperMonkey, WizardMonkey	45	22	23	48.89%	0.74%	34.28%
DartlingGunner, Druid, MonkeyVillage	22	12	10	54.55%	0.36%	33.74%
BombShooter, MonkeySub, SpikeFactory	21	11	10	52.38%	0.35%	31.02%
DartlingGunner, SpikeFactory, SuperMonkey	62	26	36	41.94%	1.02%	29.65%
Alchemist, HeliPilot, NinjaMonkey	27	13	14	48.15%	0.45%	29.30%
BananaFarm, TackShooter, WizardMonkey	73	28	45	38.36%	1.20%	27.20%
HeliPilot, MonkeyVillage, SuperMonkey	49	20	29	40.82%	0.81%	27.05%
HeliPilot, IceMonkey, MonkeyVillage	26	12	14	46.15%	0.43%	26.99%
BananaFarm, BoomerangMonkey, MortarMonkey	21	10	11	47.62%	0.35%	26.26%
EngineerMonkey, TackShooter, WizardMonkey	24	11	13	45.83%	0.40%	25.90%
Alchemist, GlueGunner, NinjaMonkey	28	12	16	42.86%	0.46%	24.53%
SniperMonkey, SpikeFactory, WizardMonkey	28	12	16	42.86%	0.46%	24.53%
Alchemist, BananaFarm, NinjaMonkey	29	12	17	41.38%	0.48%	23.45%
BananaFarm, DartlingGunner, SuperMonkey	31	12	19	38.71%	0.51%	21.56%
BananaFarm, IceMonkey, NinjaMonkey	25	10	15	40.00%	0.41%	20.80%
Druid, MonkeySub, SpikeFactory	40	11	29	27.50%	0.66%	13.66%

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)

45 rows

Advanced export