season_27_matches: sands_of_time

37 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, NinjaMonkey	65	52	13	80.00%	1.10%	70.28%
BananaFarm, IceMonkey, MonkeyBuccaneer	44	34	10	77.27%	0.75%	64.89%
BananaFarm, DartlingGunner, IceMonkey	231	155	76	67.10%	3.92%	61.04%
BananaFarm, DartMonkey, GlueGunner	60	41	19	68.33%	1.02%	56.56%
BananaFarm, BoomerangMonkey, MortarMonkey	37	26	11	70.27%	0.63%	55.54%
DartMonkey, GlueGunner, MonkeyVillage	76	50	26	65.79%	1.29%	55.12%
DartlingGunner, IceMonkey, MonkeyVillage	75	49	26	65.33%	1.27%	54.56%
HeliPilot, IceMonkey, SuperMonkey	114	72	42	63.16%	1.93%	54.30%
BananaFarm, BombShooter, WizardMonkey	77	47	30	61.04%	1.31%	50.15%
BananaFarm, EngineerMonkey, MonkeyAce	279	152	127	54.48%	4.73%	48.64%
Alchemist, MonkeyBuccaneer, SpikeFactory	81	47	34	58.02%	1.37%	47.28%
BananaFarm, Druid, MonkeySub	431	224	207	51.97%	7.31%	47.26%
GlueGunner, HeliPilot, MonkeyVillage	129	69	60	53.49%	2.19%	44.88%
BananaFarm, TackShooter, WizardMonkey	188	97	91	51.60%	3.19%	44.45%
BananaFarm, MonkeySub, TackShooter	31	19	12	61.29%	0.53%	44.14%
BananaFarm, DartlingGunner, SpikeFactory	28	17	11	60.71%	0.47%	42.62%
IceMonkey, MonkeyVillage, TackShooter	52	29	23	55.77%	0.88%	42.27%
BananaFarm, IceMonkey, SuperMonkey	42	24	18	57.14%	0.71%	42.18%
DartlingGunner, MonkeyVillage, SuperMonkey	180	88	92	48.89%	3.05%	41.59%
BananaFarm, BoomerangMonkey, MonkeySub	28	16	12	57.14%	0.47%	38.81%
HeliPilot, MonkeyVillage, SuperMonkey	49	25	24	51.02%	0.83%	37.02%
MonkeyBuccaneer, SniperMonkey, WizardMonkey	32	17	15	53.13%	0.54%	35.83%
BananaFarm, SniperMonkey, TackShooter	28	15	13	53.57%	0.47%	35.10%
GlueGunner, MonkeyVillage, TackShooter	136	59	77	43.38%	2.31%	35.05%
BananaFarm, IceMonkey, WizardMonkey	40	20	20	50.00%	0.68%	34.50%
EngineerMonkey, TackShooter, WizardMonkey	24	13	11	54.17%	0.41%	34.23%
NinjaMonkey, SniperMonkey, WizardMonkey	24	13	11	54.17%	0.41%	34.23%
BananaFarm, BombShooter, MonkeySub	50	24	26	48.00%	0.85%	34.15%
Druid, MonkeySub, SpikeFactory	44	21	23	47.73%	0.75%	32.97%
BananaFarm, DartMonkey, MortarMonkey	36	16	20	44.44%	0.61%	28.21%
BananaFarm, DartlingGunner, SuperMonkey	116	41	75	35.34%	1.97%	26.65%
BananaFarm, SniperMonkey, WizardMonkey	71	26	45	36.62%	1.20%	25.41%
BananaFarm, GlueGunner, MonkeySub	28	12	16	42.86%	0.47%	24.53%
BananaFarm, BoomerangMonkey, SuperMonkey	31	12	19	38.71%	0.53%	21.56%
SniperMonkey, TackShooter, WizardMonkey	25	10	15	40.00%	0.42%	20.80%
Alchemist, HeliPilot, NinjaMonkey	33	12	21	36.36%	0.56%	19.95%
Alchemist, BananaFarm, NinjaMonkey	30	11	19	36.67%	0.51%	19.42%

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)

37 rows

Advanced export