season_30_matches: dino_graveyard

41 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	671	451	220	67.21%	11.31%	63.66%
BananaFarm, Druid, MonkeySub	318	204	114	64.15%	5.36%	58.88%
BananaFarm, NinjaMonkey, WizardMonkey	63	43	20	68.25%	1.06%	56.76%
BananaFarm, IceMonkey, MonkeySub	445	254	191	57.08%	7.50%	52.48%
SniperMonkey, SpikeFactory, WizardMonkey	30	20	10	66.67%	0.51%	49.80%
BananaFarm, MonkeySub, SpikeFactory	37	24	13	64.86%	0.62%	49.48%
BananaFarm, DartlingGunner, NinjaMonkey	82	48	34	58.54%	1.38%	47.87%
DartlingGunner, MonkeyVillage, SuperMonkey	253	134	119	52.96%	4.26%	46.81%
BananaFarm, BoomerangMonkey, SpikeFactory	59	32	27	54.24%	0.99%	41.52%
BananaFarm, BombShooter, MonkeySub	87	45	42	51.72%	1.47%	41.22%
Alchemist, BananaFarm, NinjaMonkey	39	22	17	56.41%	0.66%	40.85%
BananaFarm, MonkeyAce, SpikeFactory	35	20	15	57.14%	0.59%	40.75%
BananaFarm, BoomerangMonkey, MonkeySub	65	34	31	52.31%	1.10%	40.17%
Alchemist, MonkeyAce, SpikeFactory	33	18	15	54.55%	0.56%	37.56%
BananaFarm, DartlingGunner, IceMonkey	76	37	39	48.68%	1.28%	37.45%
Alchemist, GlueGunner, NinjaMonkey	52	26	26	50.00%	0.88%	36.41%
BananaFarm, DartMonkey, MortarMonkey	23	13	10	56.52%	0.39%	36.26%
BananaFarm, TackShooter, WizardMonkey	156	68	88	43.59%	2.63%	35.81%
Alchemist, MonkeyBuccaneer, SpikeFactory	37	19	18	51.35%	0.62%	35.25%
BananaFarm, SniperMonkey, WizardMonkey	73	34	39	46.58%	1.23%	35.13%
HeliPilot, IceMonkey, MonkeyVillage	35	18	17	51.43%	0.59%	34.87%
BananaFarm, BombShooter, WizardMonkey	59	28	31	47.46%	0.99%	34.72%
BananaFarm, BoomerangMonkey, NinjaMonkey	50	24	26	48.00%	0.84%	34.15%
BananaFarm, DartlingGunner, SuperMonkey	101	44	57	43.56%	1.70%	33.89%
BananaFarm, DartlingGunner, WizardMonkey	22	12	10	54.55%	0.37%	33.74%
DartlingGunner, Druid, MonkeyVillage	46	22	24	47.83%	0.78%	33.39%
BananaFarm, DartlingGunner, SpikeFactory	34	17	17	50.00%	0.57%	33.19%
DartMonkey, MonkeyVillage, SuperMonkey	23	12	11	52.17%	0.39%	31.76%
SniperMonkey, TackShooter, WizardMonkey	23	12	11	52.17%	0.39%	31.76%
EngineerMonkey, TackShooter, WizardMonkey	28	14	14	50.00%	0.47%	31.48%
BananaFarm, MonkeySub, WizardMonkey	49	22	27	44.90%	0.83%	30.97%
BoomerangMonkey, NinjaMonkey, SniperMonkey	20	10	10	50.00%	0.34%	28.09%
EngineerMonkey, MonkeyAce, MonkeyVillage	48	20	28	41.67%	0.81%	27.72%
BoomerangMonkey, NinjaMonkey, SpikeFactory	29	13	16	44.83%	0.49%	26.73%
MonkeyVillage, SniperMonkey, SuperMonkey	22	10	12	45.45%	0.37%	24.65%
GlueGunner, HeliPilot, MonkeyVillage	33	13	20	39.39%	0.56%	22.72%
SniperMonkey, SpikeFactory, TackShooter	37	14	23	37.84%	0.62%	22.21%
Alchemist, IceMonkey, NinjaMonkey	29	11	18	37.93%	0.49%	20.27%
GlueGunner, MonkeyVillage, TackShooter	60	19	41	31.67%	1.01%	19.90%
BoomerangMonkey, SniperMonkey, WizardMonkey	26	10	16	38.46%	0.44%	19.76%
BananaFarm, SniperMonkey, TackShooter	49	16	33	32.65%	0.83%	19.52%

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW dino_graveyard_loadouts AS 
WITH dino_graveyard AS
    (SELECT *
    FROM matches
    WHERE map = 'dino_graveyard')
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 dino_graveyard) * 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 dino_graveyard
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM dino_graveyard)
            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;

dino_graveyard_loadouts (view)

41 rows

Advanced export