s24+_matches: banana_depot_scene

101 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
MortarMonkey, SniperMonkey, TackShooter	245	183	62	74.69%	1.10%	69.25%
BananaFarm, BombShooter, EngineerMonkey	75	58	17	77.33%	0.34%	67.86%
BananaFarm, EngineerMonkey, MonkeyAce	137	99	38	72.26%	0.62%	64.77%
BananaFarm, MortarMonkey, TackShooter	2233	1436	797	64.31%	10.04%	62.32%
BananaFarm, BombShooter, WizardMonkey	872	536	336	61.47%	3.92%	58.24%
BombShooter, SpikeFactory, WizardMonkey	199	124	75	62.31%	0.89%	55.58%
BananaFarm, TackShooter, WizardMonkey	2872	1610	1262	56.06%	12.91%	54.24%
BananaFarm, BombShooter, SpikeFactory	3632	2026	1606	55.78%	16.33%	54.17%
BananaFarm, BombShooter, MortarMonkey	295	171	124	57.97%	1.33%	52.33%
BananaFarm, BombShooter, MonkeySub	677	374	303	55.24%	3.04%	51.50%
BananaFarm, MonkeyAce, SpikeFactory	53	34	19	64.15%	0.24%	51.24%
MortarMonkey, SpikeFactory, TackShooter	156	91	65	58.33%	0.70%	50.60%
BananaFarm, BombShooter, TackShooter	130	76	54	58.46%	0.58%	49.99%
BombShooter, MortarMonkey, SpikeFactory	47	29	18	61.70%	0.21%	47.80%
SpikeFactory, TackShooter, WizardMonkey	491	256	235	52.14%	2.21%	47.72%
BananaFarm, IceMonkey, TackShooter	177	95	82	53.67%	0.80%	46.33%
HeliPilot, IceMonkey, SuperMonkey	82	46	36	56.10%	0.37%	45.36%
BananaFarm, Druid, MonkeySub	148	79	69	53.38%	0.67%	45.34%
GlueGunner, MortarMonkey, TackShooter	52	29	23	55.77%	0.23%	42.27%
GlueGunner, TackShooter, WizardMonkey	108	55	53	50.93%	0.49%	41.50%
BombShooter, MonkeySub, SpikeFactory	62	33	29	53.23%	0.28%	40.81%
DartMonkey, MonkeyBuccaneer, TackShooter	25	15	10	60.00%	0.11%	40.80%
BananaFarm, GlueGunner, TackShooter	214	99	115	46.26%	0.96%	39.58%
BombShooter, NinjaMonkey, SpikeFactory	40	22	18	55.00%	0.18%	39.58%
GlueGunner, MonkeySub, TackShooter	64	33	31	51.56%	0.29%	39.32%
HeliPilot, IceMonkey, SpikeFactory	24	14	10	58.33%	0.11%	38.61%
BananaFarm, HeliPilot, IceMonkey	52	27	25	51.92%	0.23%	38.34%
BombShooter, HeliPilot, MortarMonkey	52	27	25	51.92%	0.23%	38.34%
BananaFarm, SniperMonkey, TackShooter	164	75	89	45.73%	0.74%	38.11%
BananaFarm, BombShooter, GlueGunner	44	23	21	52.27%	0.20%	37.51%
GlueGunner, HeliPilot, MonkeySub	129	59	70	45.74%	0.58%	37.14%
BananaFarm, SpikeFactory, TackShooter	149	67	82	44.97%	0.67%	36.98%
BananaFarm, BombShooter, SniperMonkey	43	22	21	51.16%	0.19%	36.22%
SniperMonkey, SpikeFactory, TackShooter	94	43	51	45.74%	0.42%	35.67%
HeliPilot, IceMonkey, NinjaMonkey	44	22	22	50.00%	0.20%	35.23%
DartMonkey, IceMonkey, MonkeyVillage	28	15	13	53.57%	0.13%	35.10%
BombShooter, MonkeyVillage, SpikeFactory	60	28	32	46.67%	0.27%	34.04%
BombShooter, SniperMonkey, WizardMonkey	31	16	15	51.61%	0.14%	34.02%
MortarMonkey, TackShooter, WizardMonkey	31	16	15	51.61%	0.14%	34.02%
NinjaMonkey, SniperMonkey, WizardMonkey	43	21	22	48.84%	0.19%	33.90%
BananaFarm, GlueGunner, MonkeySub	84	37	47	44.05%	0.38%	33.43%
MonkeySub, SpikeFactory, TackShooter	34	17	17	50.00%	0.15%	33.19%
BananaFarm, NinjaMonkey, TackShooter	70	31	39	44.29%	0.31%	32.65%
MonkeyVillage, SniperMonkey, TackShooter	37	18	19	48.65%	0.17%	32.54%
HeliPilot, IceMonkey, MonkeyVillage	76	33	43	43.42%	0.34%	32.28%
BombShooter, SniperMonkey, SpikeFactory	30	15	15	50.00%	0.13%	32.11%
BananaFarm, MonkeySub, TackShooter	140	56	84	40.00%	0.63%	31.88%
BananaFarm, DartMonkey, SpikeFactory	23	12	11	52.17%	0.10%	31.76%
BananaFarm, GlueGunner, HeliPilot	23	12	11	52.17%	0.10%	31.76%
IceMonkey, MonkeyVillage, TackShooter	64	28	36	43.75%	0.29%	31.60%

Advanced export

JSON shape: default, array, newline-delimited

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

banana_depot_scene_loadouts (view)

101 rows

Advanced export