s24+_matches: koru_loadouts: 138 rows

138 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, MonkeyAce, SpikeFactory	178	132	46	74.16%	0.59%	67.73%
DartlingGunner, MonkeyVillage, SuperMonkey	285	207	78	72.63%	0.95%	67.46%
BombShooter, GlueGunner, SpikeFactory	65	49	16	75.38%	0.22%	64.91%
BananaFarm, DartlingGunner, IceMonkey	500	342	158	68.40%	1.66%	64.32%
BananaFarm, DartMonkey, WizardMonkey	96	68	28	70.83%	0.32%	61.74%
BananaFarm, BoomerangMonkey, MonkeyAce	47	34	13	72.34%	0.16%	59.55%
BananaFarm, TackShooter, WizardMonkey	8031	4795	3236	59.71%	26.73%	58.63%
BananaFarm, EngineerMonkey, WizardMonkey	91	61	30	67.03%	0.30%	57.37%
BananaFarm, BombShooter, MonkeyAce	38	27	11	71.05%	0.13%	56.63%
BananaFarm, IceMonkey, TackShooter	503	296	207	58.85%	1.67%	54.55%
BananaFarm, MortarMonkey, TackShooter	1458	818	640	56.10%	4.85%	53.56%
BananaFarm, BoomerangMonkey, IceMonkey	229	133	96	58.08%	0.76%	51.69%
BananaFarm, BombShooter, WizardMonkey	581	322	259	55.42%	1.93%	51.38%
BananaFarm, BoomerangMonkey, MortarMonkey	481	268	213	55.72%	1.60%	51.28%
BananaFarm, EngineerMonkey, MonkeyAce	244	140	104	57.38%	0.81%	51.17%
EngineerMonkey, IceMonkey, SniperMonkey	48	31	17	64.58%	0.16%	51.05%
BananaFarm, BoomerangMonkey, NinjaMonkey	356	195	161	54.78%	1.18%	49.61%
BoomerangMonkey, IceMonkey, MonkeySub	58	36	22	62.07%	0.19%	49.58%
BananaFarm, DartMonkey, MortarMonkey	156	89	67	57.05%	0.52%	49.28%
BananaFarm, BoomerangMonkey, SpikeFactory	571	304	267	53.24%	1.90%	49.15%
BombShooter, SpikeFactory, WizardMonkey	43	27	16	62.79%	0.14%	48.34%
BananaFarm, GlueGunner, TackShooter	883	453	430	51.30%	2.94%	48.01%
BananaFarm, DartlingGunner, GlueGunner	40	25	15	62.50%	0.13%	47.50%
BoomerangMonkey, TackShooter, WizardMonkey	42	26	16	61.90%	0.14%	47.22%
BananaFarm, NinjaMonkey, WizardMonkey	115	64	51	55.65%	0.38%	46.57%
BananaFarm, IceMonkey, NinjaMonkey	142	77	65	54.23%	0.47%	46.03%
BananaFarm, BombShooter, TackShooter	62	36	26	58.06%	0.21%	45.78%
BananaFarm, Druid, MonkeySub	433	218	215	50.35%	1.44%	45.64%
Alchemist, DartlingGunner, SuperMonkey	84	47	37	55.95%	0.28%	45.34%
BananaFarm, BombShooter, SniperMonkey	27	17	10	62.96%	0.09%	44.75%
SpikeFactory, TackShooter, WizardMonkey	429	212	217	49.42%	1.43%	44.69%
BoomerangMonkey, MonkeyVillage, NinjaMonkey	31	19	12	61.29%	0.10%	44.14%
BananaFarm, DartMonkey, IceMonkey	65	36	29	55.38%	0.22%	43.30%
DartMonkey, MonkeyBuccaneer, TackShooter	26	16	10	61.54%	0.09%	42.84%
BananaFarm, BoomerangMonkey, MonkeySub	78	42	36	53.85%	0.26%	42.78%
BananaFarm, BoomerangMonkey, WizardMonkey	221	109	112	49.32%	0.74%	42.73%
BananaFarm, BoomerangMonkey, GlueGunner	74	40	34	54.05%	0.25%	42.70%
DartlingGunner, Druid, SpikeFactory	28	17	11	60.71%	0.09%	42.62%
BananaFarm, NinjaMonkey, TackShooter	107	55	52	51.40%	0.36%	41.93%
BananaFarm, BombShooter, SpikeFactory	176	85	91	48.30%	0.59%	40.91%
BananaFarm, BoomerangMonkey, SniperMonkey	79	41	38	51.90%	0.26%	40.88%
BananaFarm, SniperMonkey, TackShooter	348	160	188	45.98%	1.16%	40.74%
NinjaMonkey, SniperMonkey, TackShooter	67	35	32	52.24%	0.22%	40.28%
BananaFarm, SpikeFactory, TackShooter	120	59	61	49.17%	0.40%	40.22%
BananaFarm, DartMonkey, GlueGunner	123	60	63	48.78%	0.41%	39.95%
BoomerangMonkey, MortarMonkey, SpikeFactory	241	111	130	46.06%	0.80%	39.77%
HeliPilot, IceMonkey, NinjaMonkey	62	32	30	51.61%	0.21%	39.17%
BananaFarm, BombShooter, NinjaMonkey	30	17	13	56.67%	0.10%	38.93%
BombShooter, TackShooter, WizardMonkey	28	16	12	57.14%	0.09%	38.81%
GlueGunner, SniperMonkey, TackShooter	63	32	31	50.79%	0.21%	38.45%

Advanced export

JSON shape: default, array, newline-delimited

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

koru_loadouts (view)

138 rows

Advanced export