season_25_matches: sands_of_time

51 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	134	101	33	75.37%	1.98%	68.08%
BananaFarm, MonkeySub, SuperMonkey	77	57	20	74.03%	1.14%	64.23%
BananaFarm, DartlingGunner, IceMonkey	124	85	39	68.55%	1.83%	60.38%
BananaFarm, BoomerangMonkey, NinjaMonkey	55	39	16	70.91%	0.81%	58.91%
BananaFarm, DartMonkey, MortarMonkey	72	49	23	68.06%	1.06%	57.29%
BananaFarm, IceMonkey, MonkeyBuccaneer	56	38	18	67.86%	0.83%	55.63%
DartlingGunner, Druid, SpikeFactory	50	33	17	66.00%	0.74%	52.87%
DartlingGunner, IceMonkey, MonkeyVillage	64	41	23	64.06%	0.94%	52.31%
BananaFarm, BoomerangMonkey, SpikeFactory	66	42	24	63.64%	0.97%	52.03%
BananaFarm, Druid, MonkeySub	364	201	163	55.22%	5.37%	50.11%
Alchemist, MonkeyBuccaneer, SpikeFactory	113	63	50	55.75%	1.67%	46.59%
BananaFarm, DartMonkey, GlueGunner	146	79	67	54.11%	2.15%	46.03%
HeliPilot, IceMonkey, SuperMonkey	40	24	16	60.00%	0.59%	44.82%
IceMonkey, MonkeyVillage, NinjaMonkey	27	17	10	62.96%	0.40%	44.75%
BananaFarm, BombShooter, DartlingGunner	53	30	23	56.60%	0.78%	43.26%
DartlingGunner, MonkeyVillage, SuperMonkey	126	65	61	51.59%	1.86%	42.86%
DartMonkey, IceMonkey, MonkeyVillage	76	41	35	53.95%	1.12%	42.74%
GlueGunner, MonkeyVillage, TackShooter	120	60	60	50.00%	1.77%	41.05%
GlueGunner, MonkeyVillage, NinjaMonkey	171	82	89	47.95%	2.52%	40.47%
BananaFarm, TackShooter, WizardMonkey	90	45	45	50.00%	1.33%	39.67%
BananaFarm, BombShooter, WizardMonkey	88	43	45	48.86%	1.30%	38.42%
DartMonkey, GlueGunner, MonkeyVillage	101	48	53	47.52%	1.49%	37.79%
BananaFarm, GlueGunner, MonkeySub	35	19	16	54.29%	0.52%	37.78%
GlueGunner, HeliPilot, MonkeyVillage	130	60	70	46.15%	1.92%	37.58%
BananaFarm, BombShooter, MonkeySub	40	21	19	52.50%	0.59%	37.02%
BananaFarm, BoomerangMonkey, WizardMonkey	36	19	17	52.78%	0.53%	36.47%
BananaFarm, BoomerangMonkey, SniperMonkey	50	25	25	50.00%	0.74%	36.14%
Alchemist, GlueGunner, NinjaMonkey	80	37	43	46.25%	1.18%	35.32%
Alchemist, NinjaMonkey, SniperMonkey	37	19	18	51.35%	0.55%	35.25%
Alchemist, HeliPilot, NinjaMonkey	59	28	31	47.46%	0.87%	34.72%
BananaFarm, BombShooter, SpikeFactory	59	28	31	47.46%	0.87%	34.72%
EngineerMonkey, TackShooter, WizardMonkey	39	19	20	48.72%	0.58%	33.03%
BananaFarm, MonkeySub, TackShooter	27	14	13	51.85%	0.40%	33.00%
HeliPilot, IceMonkey, MonkeyVillage	25	13	12	52.00%	0.37%	32.42%
EngineerMonkey, SniperMonkey, WizardMonkey	23	12	11	52.17%	0.34%	31.76%
Alchemist, BananaFarm, NinjaMonkey	36	17	19	47.22%	0.53%	30.91%
Alchemist, NinjaMonkey, TackShooter	26	13	13	50.00%	0.38%	30.78%
Druid, MonkeySub, SpikeFactory	55	24	31	43.64%	0.81%	30.53%
Alchemist, DartlingGunner, SpikeFactory	34	16	18	47.06%	0.50%	30.28%
IceMonkey, MonkeyVillage, TackShooter	48	21	27	43.75%	0.71%	29.72%
DartlingGunner, Druid, MonkeyVillage	83	33	50	39.76%	1.22%	29.23%
DartMonkey, SniperMonkey, SpikeFactory	20	10	10	50.00%	0.29%	28.09%
SniperMonkey, SpikeFactory, TackShooter	28	13	15	46.43%	0.41%	27.96%
Alchemist, Druid, MonkeyVillage	54	22	32	40.74%	0.80%	27.64%
BananaFarm, DartlingGunner, SuperMonkey	91	34	57	37.36%	1.34%	27.42%
BananaFarm, SniperMonkey, TackShooter	37	16	21	43.24%	0.55%	27.28%
BananaFarm, SniperMonkey, WizardMonkey	43	18	25	41.86%	0.63%	27.11%
MonkeyVillage, SniperMonkey, TackShooter	44	18	26	40.91%	0.65%	26.38%
BananaFarm, EngineerMonkey, SuperMonkey	24	11	13	45.83%	0.35%	25.90%
BananaFarm, MonkeyBuccaneer, WizardMonkey	37	14	23	37.84%	0.55%	22.21%

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)

51 rows

Advanced export