season_26_matches: sands_of_time

58 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, DartMonkey, GlueGunner	125	89	36	71.20%	1.72%	63.26%
DartlingGunner, IceMonkey, MonkeyVillage	77	56	21	72.73%	1.06%	62.78%
DartMonkey, IceMonkey, MonkeyVillage	40	30	10	75.00%	0.55%	61.58%
HeliPilot, IceMonkey, SuperMonkey	103	69	34	66.99%	1.42%	57.91%
BananaFarm, DartlingGunner, IceMonkey	191	122	69	63.87%	2.63%	57.06%
BananaFarm, BombShooter, WizardMonkey	119	76	43	63.87%	1.64%	55.23%
BananaFarm, EngineerMonkey, MonkeyAce	211	128	83	60.66%	2.91%	54.07%
BananaFarm, IceMonkey, MonkeyBuccaneer	58	38	20	65.52%	0.80%	53.28%
IceMonkey, MonkeyVillage, TackShooter	53	34	19	64.15%	0.73%	51.24%
BananaFarm, DartMonkey, MortarMonkey	65	40	25	61.54%	0.90%	49.71%
BananaFarm, BoomerangMonkey, NinjaMonkey	44	28	16	63.64%	0.61%	49.42%
Alchemist, MonkeyBuccaneer, SpikeFactory	156	89	67	57.05%	2.15%	49.28%
BananaFarm, BoomerangMonkey, SniperMonkey	46	29	17	63.04%	0.63%	49.09%
DartlingGunner, MonkeyVillage, SuperMonkey	200	111	89	55.50%	2.76%	48.61%
BananaFarm, BoomerangMonkey, SpikeFactory	71	42	29	59.15%	0.98%	47.72%
BananaFarm, Druid, MonkeySub	345	180	165	52.17%	4.76%	46.90%
BananaFarm, MonkeySub, SuperMonkey	45	27	18	60.00%	0.62%	45.69%
Alchemist, HeliPilot, NinjaMonkey	59	34	25	57.63%	0.81%	45.02%
DartMonkey, GlueGunner, MonkeyVillage	103	54	49	52.43%	1.42%	42.78%
GlueGunner, HeliPilot, MonkeyVillage	176	88	88	50.00%	2.43%	42.61%
BananaFarm, BoomerangMonkey, WizardMonkey	40	23	17	57.50%	0.55%	42.18%
BananaFarm, TackShooter, WizardMonkey	152	76	76	50.00%	2.10%	42.05%
BananaFarm, SniperMonkey, TackShooter	62	33	29	53.23%	0.86%	40.81%
BananaFarm, DartMonkey, SniperMonkey	31	18	13	58.06%	0.43%	40.69%
Alchemist, Druid, MonkeyVillage	50	27	23	54.00%	0.69%	40.19%
DartlingGunner, Druid, MonkeyVillage	66	34	32	51.52%	0.91%	39.46%
Alchemist, DartlingGunner, SpikeFactory	38	21	17	55.26%	0.52%	39.45%
GlueGunner, MonkeyVillage, NinjaMonkey	93	46	47	49.46%	1.28%	39.30%
MonkeyAce, SniperMonkey, WizardMonkey	28	16	12	57.14%	0.39%	38.81%
BananaFarm, BombShooter, DartlingGunner	26	15	11	57.69%	0.36%	38.70%
GlueGunner, MonkeySub, SuperMonkey	31	17	14	54.84%	0.43%	37.32%
NinjaMonkey, SniperMonkey, WizardMonkey	22	12	10	54.55%	0.30%	33.74%
BananaFarm, DartlingGunner, SuperMonkey	173	71	102	41.04%	2.39%	33.71%
BananaFarm, BoomerangMonkey, SuperMonkey	41	20	21	48.78%	0.57%	33.48%
BombShooter, DartlingGunner, MonkeyBuccaneer	23	12	11	52.17%	0.32%	31.76%
MonkeyVillage, SniperMonkey, TackShooter	54	24	30	44.44%	0.74%	31.19%
BananaFarm, BombShooter, SpikeFactory	41	19	22	46.34%	0.57%	31.08%
SpikeFactory, TackShooter, WizardMonkey	22	11	11	50.00%	0.30%	29.11%
GlueGunner, MonkeyVillage, TackShooter	119	45	74	37.82%	1.64%	29.10%
Alchemist, GlueGunner, NinjaMonkey	47	20	27	42.55%	0.65%	28.42%
BananaFarm, GlueGunner, TackShooter	28	13	15	46.43%	0.39%	27.96%
Alchemist, NinjaMonkey, SniperMonkey	48	20	28	41.67%	0.66%	27.72%
EngineerMonkey, SniperMonkey, SuperMonkey	23	11	12	47.83%	0.32%	27.41%
Druid, MonkeySub, SpikeFactory	37	16	21	43.24%	0.51%	27.28%
SniperMonkey, SuperMonkey, TackShooter	40	17	23	42.50%	0.55%	27.18%
BananaFarm, SniperMonkey, WizardMonkey	58	23	35	39.66%	0.80%	27.07%
BananaFarm, BoomerangMonkey, MonkeySub	26	12	14	46.15%	0.36%	26.99%
DartlingGunner, SniperMonkey, SuperMonkey	21	10	11	47.62%	0.29%	26.26%
MonkeyBuccaneer, SniperMonkey, SuperMonkey	21	10	11	47.62%	0.29%	26.26%
BananaFarm, DartlingGunner, SpikeFactory	26	11	15	42.31%	0.36%	23.32%

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)

58 rows

Advanced export