season_29_matches: sands_of_time

46 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, EngineerMonkey	71	57	14	80.28%	1.08%	71.03%
BananaFarm, EngineerMonkey, MonkeyAce	236	164	72	69.49%	3.59%	63.62%
BananaFarm, BombShooter, WizardMonkey	81	57	24	70.37%	1.23%	60.43%
HeliPilot, IceMonkey, NinjaMonkey	41	29	12	70.73%	0.62%	56.80%
BananaFarm, MonkeySub, TackShooter	84	56	28	66.67%	1.28%	56.59%
BananaFarm, Druid, MonkeySub	652	387	265	59.36%	9.92%	55.59%
DartlingGunner, IceMonkey, MonkeyVillage	46	31	15	67.39%	0.70%	53.84%
BananaFarm, IceMonkey, WizardMonkey	36	24	12	66.67%	0.55%	51.27%
BananaFarm, DartlingGunner, IceMonkey	158	88	70	55.70%	2.40%	47.95%
BananaFarm, IceMonkey, MonkeySub	791	405	386	51.20%	12.03%	47.72%
GlueGunner, HeliPilot, MonkeyVillage	60	36	24	60.00%	0.91%	47.60%
BananaFarm, TackShooter, WizardMonkey	322	166	156	51.55%	4.90%	46.09%
Alchemist, MonkeyBuccaneer, SpikeFactory	51	30	21	58.82%	0.78%	45.32%
DartlingGunner, MonkeyVillage, SuperMonkey	88	49	39	55.68%	1.34%	45.30%
DartlingGunner, SpikeFactory, SuperMonkey	30	18	12	60.00%	0.46%	42.47%
BananaFarm, BoomerangMonkey, MortarMonkey	34	20	14	58.82%	0.52%	42.28%
BananaFarm, BoomerangMonkey, MonkeySub	52	29	23	55.77%	0.79%	42.27%
BananaFarm, BombShooter, MonkeySub	131	65	66	49.62%	1.99%	41.06%
IceMonkey, MonkeyVillage, WizardMonkey	27	16	11	59.26%	0.41%	40.73%
BananaFarm, DartlingGunner, NinjaMonkey	33	19	14	57.58%	0.50%	40.71%
BananaFarm, NinjaMonkey, WizardMonkey	141	68	73	48.23%	2.14%	39.98%
BananaFarm, EngineerMonkey, MonkeySub	30	17	13	56.67%	0.46%	38.93%
BananaFarm, BombShooter, DartlingGunner	28	16	12	57.14%	0.43%	38.81%
MonkeyVillage, SniperMonkey, TackShooter	31	16	15	51.61%	0.47%	34.02%
BananaFarm, GlueGunner, MonkeySub	22	12	10	54.55%	0.33%	33.74%
Alchemist, BananaFarm, NinjaMonkey	36	18	18	50.00%	0.55%	33.67%
BananaFarm, BoomerangMonkey, WizardMonkey	39	19	20	48.72%	0.59%	33.03%
BananaFarm, MonkeySub, WizardMonkey	28	14	14	50.00%	0.43%	31.48%
NinjaMonkey, SniperMonkey, WizardMonkey	28	14	14	50.00%	0.43%	31.48%
BananaFarm, BoomerangMonkey, SpikeFactory	70	30	40	42.86%	1.06%	31.26%
BananaFarm, BoomerangMonkey, NinjaMonkey	88	36	52	40.91%	1.34%	30.64%
BananaFarm, SniperMonkey, WizardMonkey	55	24	31	43.64%	0.84%	30.53%
BananaFarm, MortarMonkey, TackShooter	27	13	14	48.15%	0.41%	29.30%
DartlingGunner, Druid, MonkeyVillage	22	11	11	50.00%	0.33%	29.11%
MonkeyVillage, TackShooter, WizardMonkey	28	13	15	46.43%	0.43%	27.96%
GlueGunner, MonkeyVillage, TackShooter	124	43	81	34.68%	1.89%	26.30%
GlueGunner, SniperMonkey, WizardMonkey	24	11	13	45.83%	0.37%	25.90%
Alchemist, HeliPilot, NinjaMonkey	45	18	27	40.00%	0.68%	25.69%
BombShooter, MonkeyVillage, SpikeFactory	39	16	23	41.03%	0.59%	25.59%
BananaFarm, SniperMonkey, TackShooter	49	19	30	38.78%	0.75%	25.13%
BananaFarm, DartlingGunner, SuperMonkey	57	21	36	36.84%	0.87%	24.32%
SniperMonkey, TackShooter, WizardMonkey	38	15	23	39.47%	0.58%	23.93%
EngineerMonkey, SniperMonkey, WizardMonkey	23	10	13	43.48%	0.35%	23.22%
IceMonkey, MonkeyVillage, TackShooter	36	13	23	36.11%	0.55%	20.42%
Druid, MonkeySub, SpikeFactory	26	10	16	38.46%	0.40%	19.76%
EngineerMonkey, TackShooter, WizardMonkey	37	11	26	29.73%	0.56%	15.00%

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)

46 rows

Advanced export