season_28_matches: dino_graveyard

41 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce	1058	742	316	70.13%	15.38%	67.37%
BananaFarm, BombShooter, WizardMonkey	73	46	27	63.01%	1.06%	51.94%
BananaFarm, Druid, MonkeySub	566	302	264	53.36%	8.23%	49.25%
BananaFarm, BoomerangMonkey, EngineerMonkey	75	45	30	60.00%	1.09%	48.91%
BananaFarm, DartlingGunner, IceMonkey	67	39	28	58.21%	0.97%	46.40%
Alchemist, MonkeyBuccaneer, SpikeFactory	108	58	50	53.70%	1.57%	44.30%
BananaFarm, DartMonkey, WizardMonkey	31	19	12	61.29%	0.45%	44.14%
BananaFarm, BoomerangMonkey, SniperMonkey	28	17	11	60.71%	0.41%	42.62%
Alchemist, MonkeyAce, SpikeFactory	41	23	18	56.10%	0.60%	40.91%
BananaFarm, DartMonkey, GlueGunner	31	18	13	58.06%	0.45%	40.69%
BananaFarm, TackShooter, WizardMonkey	135	66	69	48.89%	1.96%	40.46%
BananaFarm, GlueGunner, MonkeySub	40	22	18	55.00%	0.58%	39.58%
BananaFarm, BombShooter, MonkeySub	240	110	130	45.83%	3.49%	39.53%
BananaFarm, BoomerangMonkey, SpikeFactory	98	48	50	48.98%	1.42%	39.08%
Alchemist, BananaFarm, NinjaMonkey	46	24	22	52.17%	0.67%	37.74%
DartlingGunner, MonkeyVillage, SuperMonkey	146	66	80	45.21%	2.12%	37.13%
BananaFarm, DartlingGunner, NinjaMonkey	29	16	13	55.17%	0.42%	37.07%
HeliPilot, IceMonkey, SuperMonkey	61	30	31	49.18%	0.89%	36.63%
BananaFarm, BoomerangMonkey, NinjaMonkey	169	72	97	42.60%	2.46%	35.15%
BananaFarm, MonkeyAce, SpikeFactory	28	15	13	53.57%	0.41%	35.10%
BananaFarm, BoomerangMonkey, MonkeySub	33	17	16	51.52%	0.48%	34.46%
BananaFarm, MonkeyAce, WizardMonkey	24	13	11	54.17%	0.35%	34.23%
EngineerMonkey, MonkeyAce, SpikeFactory	34	17	17	50.00%	0.49%	33.19%
SniperMonkey, SpikeFactory, WizardMonkey	27	14	13	51.85%	0.39%	33.00%
IceMonkey, MonkeyVillage, NinjaMonkey	25	13	12	52.00%	0.36%	32.42%
DartlingGunner, SpikeFactory, SuperMonkey	34	16	18	47.06%	0.49%	30.28%
GlueGunner, HeliPilot, MonkeyVillage	104	41	63	39.42%	1.51%	30.03%
Druid, MonkeySub, SpikeFactory	35	16	19	45.71%	0.51%	29.21%
DartMonkey, GlueGunner, MonkeyVillage	49	21	28	42.86%	0.71%	29.00%
BoomerangMonkey, SniperMonkey, SuperMonkey	25	12	13	48.00%	0.36%	28.42%
BananaFarm, SniperMonkey, WizardMonkey	59	24	35	40.68%	0.86%	28.14%
HeliPilot, MonkeyVillage, SuperMonkey	45	19	26	42.22%	0.65%	27.79%
GlueGunner, MonkeyVillage, TackShooter	84	32	52	38.10%	1.22%	27.71%
DartlingGunner, Druid, MonkeyVillage	37	16	21	43.24%	0.54%	27.28%
BananaFarm, DartlingGunner, SuperMonkey	130	46	84	35.38%	1.89%	27.16%
Alchemist, HeliPilot, NinjaMonkey	55	22	33	40.00%	0.80%	27.05%
BananaFarm, NinjaMonkey, WizardMonkey	35	15	20	42.86%	0.51%	26.46%
BananaFarm, BoomerangMonkey, MortarMonkey	23	10	13	43.48%	0.33%	23.22%
BananaFarm, BoomerangMonkey, WizardMonkey	33	12	21	36.36%	0.48%	19.95%
Alchemist, DartlingGunner, SpikeFactory	37	11	26	29.73%	0.54%	15.00%
BananaFarm, DartlingGunner, SpikeFactory	33	10	23	30.30%	0.48%	14.62%

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