season_26_matches: up_on_the_roof

42 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
HeliPilot, IceMonkey, SuperMonkey	113	81	32	71.68%	1.96%	63.37%
GlueGunner, MonkeyVillage, SuperMonkey	51	36	15	70.59%	0.88%	58.08%
DartlingGunner, IceMonkey, MonkeyVillage	38	27	11	71.05%	0.66%	56.63%
Alchemist, HeliPilot, NinjaMonkey	35	25	10	71.43%	0.61%	56.46%
IceMonkey, MonkeyVillage, SuperMonkey	124	78	46	62.90%	2.15%	54.40%
DartlingGunner, SpikeFactory, SuperMonkey	76	49	27	64.47%	1.32%	53.71%
MonkeyVillage, SniperMonkey, SuperMonkey	234	139	95	59.40%	4.06%	53.11%
GlueGunner, MonkeyVillage, TackShooter	288	167	121	57.99%	5.00%	52.29%
DartlingGunner, MonkeyVillage, SuperMonkey	342	194	148	56.73%	5.93%	51.47%
Alchemist, GlueGunner, NinjaMonkey	98	56	42	57.14%	1.70%	47.34%
BoomerangMonkey, MonkeyVillage, SuperMonkey	50	30	20	60.00%	0.87%	46.42%
DartMonkey, GlueGunner, MonkeyVillage	215	114	101	53.02%	3.73%	46.35%
DartMonkey, IceMonkey, MonkeyVillage	30	19	11	63.33%	0.52%	46.09%
BananaFarm, BombShooter, WizardMonkey	41	25	16	60.98%	0.71%	46.04%
BananaFarm, DartMonkey, MortarMonkey	90	49	41	54.44%	1.56%	44.16%
DartMonkey, MonkeyVillage, SuperMonkey	91	49	42	53.85%	1.58%	43.60%
MonkeyVillage, SniperMonkey, TackShooter	45	26	19	57.78%	0.78%	43.35%
GlueGunner, HeliPilot, MonkeyVillage	125	65	60	52.00%	2.17%	43.24%
Alchemist, MonkeyVillage, NinjaMonkey	40	23	17	57.50%	0.69%	42.18%
HeliPilot, MonkeyVillage, SuperMonkey	175	86	89	49.14%	3.04%	41.74%
MonkeyAce, SniperMonkey, WizardMonkey	39	22	17	56.41%	0.68%	40.85%
BananaFarm, BoomerangMonkey, SpikeFactory	33	19	14	57.58%	0.57%	40.71%
BananaFarm, TackShooter, WizardMonkey	80	41	39	51.25%	1.39%	40.30%
DartlingGunner, Druid, MonkeyVillage	60	31	29	51.67%	1.04%	39.02%
BananaFarm, DartMonkey, WizardMonkey	57	29	28	50.88%	0.99%	37.90%
BananaFarm, IceMonkey, SuperMonkey	29	16	13	55.17%	0.50%	37.07%
BananaFarm, DartlingGunner, SuperMonkey	82	38	44	46.34%	1.42%	35.55%
IceMonkey, MonkeyVillage, TackShooter	54	26	28	48.15%	0.94%	34.82%
Druid, MonkeyVillage, SuperMonkey	26	14	12	53.85%	0.45%	34.68%
GlueGunner, MonkeyVillage, NinjaMonkey	67	31	36	46.27%	1.16%	34.33%
BananaFarm, BoomerangMonkey, WizardMonkey	24	13	11	54.17%	0.42%	34.23%
MonkeyVillage, SuperMonkey, TackShooter	21	11	10	52.38%	0.36%	31.02%
BananaFarm, DartMonkey, SpikeFactory	26	13	13	50.00%	0.45%	30.78%
SniperMonkey, SpikeFactory, WizardMonkey	46	19	27	41.30%	0.80%	27.08%
SniperMonkey, SuperMonkey, TackShooter	44	18	26	40.91%	0.76%	26.38%
BananaFarm, DartMonkey, GlueGunner	33	14	19	42.42%	0.57%	25.56%
BananaFarm, SniperMonkey, WizardMonkey	46	18	28	39.13%	0.80%	25.03%
SniperMonkey, SpikeFactory, TackShooter	22	10	12	45.45%	0.38%	24.65%
SniperMonkey, SuperMonkey, WizardMonkey	22	10	12	45.45%	0.38%	24.65%
GlueGunner, SniperMonkey, WizardMonkey	31	13	18	41.94%	0.54%	24.56%
BananaFarm, SniperMonkey, TackShooter	47	17	30	36.17%	0.82%	22.43%
Alchemist, NinjaMonkey, SniperMonkey	27	11	16	40.74%	0.47%	22.21%

Advanced export

JSON shape: default, array, newline-delimited

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

up_on_the_roof_loadouts (view)

42 rows

Advanced export