season_28_matches: sands_of_time

44 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
DartlingGunner, IceMonkey, MonkeyVillage	42	32	10	76.19%	0.63%	63.31%
BananaFarm, EngineerMonkey, MonkeyAce	293	183	110	62.46%	4.39%	56.91%
BananaFarm, BoomerangMonkey, EngineerMonkey	92	61	31	66.30%	1.38%	56.65%
HeliPilot, IceMonkey, SuperMonkey	92	61	31	66.30%	1.38%	56.65%
BananaFarm, DartlingGunner, IceMonkey	220	137	83	62.27%	3.30%	55.87%
BananaFarm, BombShooter, WizardMonkey	74	49	25	66.22%	1.11%	55.44%
BananaFarm, Druid, MonkeySub	791	430	361	54.36%	11.86%	50.89%
BananaFarm, IceMonkey, WizardMonkey	61	38	23	62.30%	0.91%	50.13%
HeliPilot, IceMonkey, NinjaMonkey	36	23	13	63.89%	0.54%	48.20%
BananaFarm, IceMonkey, MonkeyBuccaneer	28	18	10	64.29%	0.42%	46.54%
BananaFarm, BoomerangMonkey, NinjaMonkey	135	73	62	54.07%	2.02%	45.67%
GlueGunner, HeliPilot, MonkeyVillage	125	68	57	54.40%	1.87%	45.67%
HeliPilot, MonkeyVillage, SuperMonkey	34	21	13	61.76%	0.51%	45.43%
BananaFarm, IceMonkey, SuperMonkey	38	23	15	60.53%	0.57%	44.98%
BananaFarm, BombShooter, MonkeySub	243	118	125	48.56%	3.64%	42.28%
BananaFarm, SniperMonkey, TackShooter	46	26	20	56.52%	0.69%	42.20%
Alchemist, HeliPilot, NinjaMonkey	45	25	20	55.56%	0.67%	41.04%
IceMonkey, MonkeyVillage, NinjaMonkey	62	33	29	53.23%	0.93%	40.81%
BananaFarm, BoomerangMonkey, MortarMonkey	34	19	15	55.88%	0.51%	39.19%
BananaFarm, TackShooter, WizardMonkey	289	129	160	44.64%	4.33%	38.91%
IceMonkey, MonkeyVillage, TackShooter	26	15	11	57.69%	0.39%	38.70%
BananaFarm, NinjaMonkey, WizardMonkey	48	25	23	52.08%	0.72%	37.95%
BananaFarm, GlueGunner, MonkeySub	40	21	19	52.50%	0.60%	37.02%
BananaFarm, BombShooter, MortarMonkey	27	15	12	55.56%	0.40%	36.81%
DartlingGunner, SpikeFactory, SuperMonkey	27	15	12	55.56%	0.40%	36.81%
DartlingGunner, MonkeyVillage, SuperMonkey	94	44	50	46.81%	1.41%	36.72%
BananaFarm, BoomerangMonkey, SpikeFactory	89	41	48	46.07%	1.33%	35.71%
BananaFarm, MonkeySub, TackShooter	28	15	13	53.57%	0.42%	35.10%
DartlingGunner, IceMonkey, NinjaMonkey	28	15	13	53.57%	0.42%	35.10%
BananaFarm, BoomerangMonkey, MonkeySub	52	25	27	48.08%	0.78%	34.50%
Druid, MonkeySub, SpikeFactory	31	16	15	51.61%	0.46%	34.02%
Alchemist, MonkeyBuccaneer, SpikeFactory	64	29	35	45.31%	0.96%	33.12%
BananaFarm, BoomerangMonkey, WizardMonkey	23	12	11	52.17%	0.34%	31.76%
Alchemist, BananaFarm, NinjaMonkey	52	23	29	44.23%	0.78%	30.73%
GlueGunner, MonkeyVillage, TackShooter	197	73	124	37.06%	2.95%	30.31%
DartMonkey, GlueGunner, MonkeyVillage	41	18	23	43.90%	0.61%	28.71%
BananaFarm, SniperMonkey, WizardMonkey	52	21	31	40.38%	0.78%	27.05%
NinjaMonkey, TackShooter, WizardMonkey	35	15	20	42.86%	0.52%	26.46%
BananaFarm, MonkeySub, SuperMonkey	21	10	11	47.62%	0.31%	26.26%
BananaFarm, MortarMonkey, TackShooter	22	10	12	45.45%	0.33%	24.65%
BananaFarm, DartlingGunner, SuperMonkey	80	28	52	35.00%	1.20%	24.55%
HeliPilot, IceMonkey, MonkeyVillage	23	10	13	43.48%	0.34%	23.22%
BananaFarm, BoomerangMonkey, SuperMonkey	24	10	14	41.67%	0.36%	21.94%
SniperMonkey, TackShooter, WizardMonkey	33	10	23	30.30%	0.49%	14.62%

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)

44 rows

Advanced export