season_31_matches: sands_of_time

43 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, DartlingGunner, IceMonkey	171	113	58	66.08%	2.79%	58.99%
DartlingGunner, Druid, SpikeFactory	42	29	13	69.05%	0.69%	55.07%
BananaFarm, Druid, MonkeySub	418	249	169	59.57%	6.83%	54.86%
BananaFarm, BoomerangMonkey, SniperMonkey	47	32	15	68.09%	0.77%	54.76%
BananaFarm, TackShooter, WizardMonkey	377	223	154	59.15%	6.16%	54.19%
BananaFarm, EngineerMonkey, MonkeyAce	146	89	57	60.96%	2.39%	53.05%
BananaFarm, DartlingGunner, NinjaMonkey	100	61	39	61.00%	1.63%	51.44%
DartlingGunner, IceMonkey, NinjaMonkey	28	18	10	64.29%	0.46%	46.54%
BananaFarm, EngineerMonkey, WizardMonkey	80	45	35	56.25%	1.31%	45.38%
BananaFarm, NinjaMonkey, WizardMonkey	91	50	41	54.95%	1.49%	44.72%
DartlingGunner, IceMonkey, MonkeyVillage	46	27	19	58.70%	0.75%	44.47%
BananaFarm, BoomerangMonkey, NinjaMonkey	126	65	61	51.59%	2.06%	42.86%
DartlingGunner, MonkeyVillage, SuperMonkey	249	122	127	49.00%	4.07%	42.79%
BananaFarm, MonkeySub, WizardMonkey	28	17	11	60.71%	0.46%	42.62%
BananaFarm, BoomerangMonkey, SpikeFactory	40	23	17	57.50%	0.65%	42.18%
HeliPilot, IceMonkey, SuperMonkey	27	16	11	59.26%	0.44%	40.73%
BananaFarm, BombShooter, WizardMonkey	50	27	23	54.00%	0.82%	40.19%
BananaFarm, IceMonkey, MonkeySub	215	98	117	45.58%	3.51%	38.92%
BoomerangMonkey, SniperMonkey, SuperMonkey	26	15	11	57.69%	0.42%	38.70%
SniperMonkey, SpikeFactory, TackShooter	26	15	11	57.69%	0.42%	38.70%
BananaFarm, BombShooter, MonkeySub	65	33	32	50.77%	1.06%	38.62%
BananaFarm, HeliPilot, IceMonkey	43	23	20	53.49%	0.70%	38.58%
BananaFarm, BoomerangMonkey, WizardMonkey	61	31	30	50.82%	1.00%	38.27%
BananaFarm, DartlingGunner, WizardMonkey	29	16	13	55.17%	0.47%	37.07%
HeliPilot, IceMonkey, MonkeyVillage	111	50	61	45.05%	1.81%	35.79%
GlueGunner, HeliPilot, MonkeyVillage	39	20	19	51.28%	0.64%	35.59%
DartlingGunner, Druid, MonkeyVillage	33	17	16	51.52%	0.54%	34.46%
Alchemist, MonkeyBuccaneer, SpikeFactory	43	21	22	48.84%	0.70%	33.90%
BananaFarm, SniperMonkey, TackShooter	46	22	24	47.83%	0.75%	33.39%
BananaFarm, SniperMonkey, WizardMonkey	86	37	49	43.02%	1.41%	32.56%
Alchemist, GlueGunner, NinjaMonkey	23	12	11	52.17%	0.38%	31.76%
BananaFarm, BoomerangMonkey, MonkeySub	34	16	18	47.06%	0.56%	30.28%
BananaFarm, DartlingGunner, SuperMonkey	73	30	43	41.10%	1.19%	29.81%
EngineerMonkey, MonkeyVillage, SpikeFactory	33	15	18	45.45%	0.54%	28.47%
EngineerMonkey, TackShooter, WizardMonkey	33	15	18	45.45%	0.54%	28.47%
GlueGunner, MonkeyVillage, TackShooter	92	35	57	38.04%	1.50%	28.12%
BoomerangMonkey, SniperMonkey, WizardMonkey	20	10	10	50.00%	0.33%	28.09%
DartMonkey, MonkeyVillage, SuperMonkey	23	11	12	47.83%	0.38%	27.41%
Druid, MonkeySub, SpikeFactory	26	12	14	46.15%	0.42%	26.99%
MonkeySub, MonkeyVillage, SuperMonkey	48	19	29	39.58%	0.78%	25.75%
DartMonkey, SniperMonkey, SpikeFactory	30	13	17	43.33%	0.49%	25.60%
BananaFarm, EngineerMonkey, SuperMonkey	33	14	19	42.42%	0.54%	25.56%
BananaFarm, IceMonkey, NinjaMonkey	26	11	15	42.31%	0.42%	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)

43 rows

Advanced export