season_30_matches: sands_of_time

37 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, EngineerMonkey	51	38	13	74.51%	0.86%	62.55%
BananaFarm, DartlingGunner, NinjaMonkey	84	58	26	69.05%	1.41%	59.16%
BananaFarm, EngineerMonkey, MonkeyAce	144	96	48	66.67%	2.42%	58.97%
BananaFarm, Druid, MonkeySub	411	259	152	63.02%	6.91%	58.35%
DartlingGunner, IceMonkey, MonkeyVillage	55	37	18	67.27%	0.92%	54.87%
BananaFarm, IceMonkey, MonkeySub	685	376	309	54.89%	11.52%	51.16%
DartlingGunner, IceMonkey, NinjaMonkey	31	20	11	64.52%	0.52%	47.67%
BananaFarm, TackShooter, WizardMonkey	285	150	135	52.63%	4.79%	46.83%
BananaFarm, DartlingGunner, IceMonkey	153	83	70	54.25%	2.57%	46.35%
DartlingGunner, MonkeyVillage, SuperMonkey	133	71	62	53.38%	2.24%	44.91%
BananaFarm, NinjaMonkey, WizardMonkey	76	42	34	55.26%	1.28%	44.08%
Alchemist, BananaFarm, NinjaMonkey	49	28	21	57.14%	0.82%	43.29%
BananaFarm, BombShooter, WizardMonkey	54	30	24	55.56%	0.91%	42.30%
BananaFarm, BoomerangMonkey, SpikeFactory	73	39	34	53.42%	1.23%	41.98%
BananaFarm, BombShooter, MonkeySub	82	42	40	51.22%	1.38%	40.40%
BananaFarm, BoomerangMonkey, NinjaMonkey	93	47	46	50.54%	1.56%	40.38%
BananaFarm, IceMonkey, SuperMonkey	38	21	17	55.26%	0.64%	39.45%
EngineerMonkey, TackShooter, WizardMonkey	35	19	16	54.29%	0.59%	37.78%
BananaFarm, BoomerangMonkey, MonkeySub	56	28	28	50.00%	0.94%	36.90%
BananaFarm, MonkeySub, WizardMonkey	39	20	19	51.28%	0.66%	35.59%
IceMonkey, MonkeyVillage, NinjaMonkey	30	16	14	53.33%	0.50%	35.48%
BananaFarm, SniperMonkey, WizardMonkey	70	33	37	47.14%	1.18%	35.45%
GlueGunner, MonkeyVillage, TackShooter	114	50	64	43.86%	1.92%	34.75%
MonkeyVillage, SniperMonkey, TackShooter	26	14	12	53.85%	0.44%	34.68%
BananaFarm, DartlingGunner, SuperMonkey	73	33	40	45.21%	1.23%	33.79%
HeliPilot, IceMonkey, MonkeyVillage	69	31	38	44.93%	1.16%	33.19%
BananaFarm, SniperMonkey, TackShooter	59	27	32	45.76%	0.99%	33.05%
BananaFarm, IceMonkey, NinjaMonkey	38	18	20	47.37%	0.64%	31.49%
SniperMonkey, TackShooter, WizardMonkey	41	19	22	46.34%	0.69%	31.08%
BananaFarm, BoomerangMonkey, WizardMonkey	36	17	19	47.22%	0.61%	30.91%
Alchemist, MonkeyBuccaneer, SpikeFactory	31	15	16	48.39%	0.52%	30.79%
SniperMonkey, SuperMonkey, WizardMonkey	25	12	13	48.00%	0.42%	28.42%
BananaFarm, MonkeySub, TackShooter	61	24	37	39.34%	1.03%	27.08%
BananaFarm, DartlingGunner, WizardMonkey	28	12	16	42.86%	0.47%	24.53%
GlueGunner, HeliPilot, MonkeyVillage	32	13	19	40.63%	0.54%	23.61%
Alchemist, HeliPilot, NinjaMonkey	28	11	17	39.29%	0.47%	21.20%
DartlingGunner, Druid, MonkeyVillage	32	11	21	34.38%	0.54%	17.92%

Advanced export

JSON shape: default, array, newline-delimited

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

sands_of_time_loadouts (view)

37 rows

Advanced export