times_up_loadouts (view)

110 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
MortarMonkey, SniperMonkey, TackShooter 201 147 54 73.13% 0.88% 67.01%
HeliPilot, IceMonkey, NinjaMonkey 54 41 13 75.93% 0.24% 64.52%
BananaFarm, BombShooter, TackShooter 288 189 99 65.63% 1.26% 60.14%
BananaFarm, IceMonkey, TackShooter 2783 1707 1076 61.34% 12.14% 59.53%
BananaFarm, GlueGunner, TackShooter 1021 627 394 61.41% 4.45% 58.42%
BananaFarm, BoomerangMonkey, IceMonkey 84 57 27 67.86% 0.37% 57.87%
Alchemist, DartlingGunner, SuperMonkey 92 62 30 67.39% 0.40% 57.81%
BananaFarm, MortarMonkey, TackShooter 1457 878 579 60.26% 6.35% 57.75%
BananaFarm, BoomerangMonkey, NinjaMonkey 233 148 85 63.52% 1.02% 57.34%
IceMonkey, NinjaMonkey, SniperMonkey 50 35 15 70.00% 0.22% 57.30%
BananaFarm, BoomerangMonkey, GlueGunner 111 73 38 65.77% 0.48% 56.94%
BananaFarm, IceMonkey, NinjaMonkey 253 153 100 60.47% 1.10% 54.45%
IceMonkey, MonkeyBuccaneer, TackShooter 54 35 19 64.81% 0.24% 52.08%
BananaFarm, TackShooter, WizardMonkey 2611 1376 1235 52.70% 11.39% 50.79%
DartMonkey, IceMonkey, MonkeyVillage 74 45 29 60.81% 0.32% 49.69%
BananaFarm, MonkeySub, TackShooter 1098 570 528 51.91% 4.79% 48.96%
BananaFarm, BoomerangMonkey, SniperMonkey 66 40 26 60.61% 0.29% 48.82%
BananaFarm, GlueGunner, MonkeySub 201 110 91 54.73% 0.88% 47.84%
BananaFarm, BombShooter, WizardMonkey 626 320 306 51.12% 2.73% 47.20%
BananaFarm, BoomerangMonkey, MonkeySub 151 81 70 53.64% 0.66% 45.69%
BananaFarm, BombShooter, MonkeySub 448 224 224 50.00% 1.95% 45.37%
BananaFarm, BoomerangMonkey, MortarMonkey 144 77 67 53.47% 0.63% 45.33%
IceMonkey, TackShooter, WizardMonkey 56 32 24 57.14% 0.24% 44.18%
GlueGunner, SniperMonkey, TackShooter 62 35 27 56.45% 0.27% 44.11%
IceMonkey, SniperMonkey, WizardMonkey 28 17 11 60.71% 0.12% 42.62%
BananaFarm, DartMonkey, MonkeySub 38 22 16 57.89% 0.17% 42.20%
BoomerangMonkey, GlueGunner, MonkeySub 40 23 17 57.50% 0.17% 42.18%
EngineerMonkey, TackShooter, WizardMonkey 92 48 44 52.17% 0.40% 41.97%
GlueGunner, MonkeySub, TackShooter 136 68 68 50.00% 0.59% 41.60%
Druid, GlueGunner, MonkeySub 43 24 19 55.81% 0.19% 40.97%
BananaFarm, HeliPilot, IceMonkey 41 23 18 56.10% 0.18% 40.91%
BananaFarm, DartMonkey, IceMonkey 64 34 30 53.13% 0.28% 40.90%
BananaFarm, SniperMonkey, TackShooter 155 74 81 47.74% 0.68% 39.88%
BananaFarm, BombShooter, MortarMonkey 103 51 52 49.51% 0.45% 39.86%
BananaFarm, BoomerangMonkey, WizardMonkey 113 55 58 48.67% 0.49% 39.46%
IceMonkey, MonkeySub, TackShooter 66 34 32 51.52% 0.29% 39.46%
SniperMonkey, SpikeFactory, WizardMonkey 38 21 17 55.26% 0.17% 39.45%
BombShooter, HeliPilot, WizardMonkey 49 26 23 53.06% 0.21% 39.09%
SpikeFactory, TackShooter, WizardMonkey 49 26 23 53.06% 0.21% 39.09%
BombShooter, SniperMonkey, WizardMonkey 28 16 12 57.14% 0.12% 38.81%
GlueGunner, MonkeyBuccaneer, WizardMonkey 24 14 10 58.33% 0.10% 38.61%
IceMonkey, SniperMonkey, TackShooter 100 48 52 48.00% 0.44% 38.21%
BananaFarm, NinjaMonkey, WizardMonkey 147 67 80 45.58% 0.64% 37.53%
GlueGunner, MonkeyVillage, TackShooter 512 214 298 41.80% 2.23% 37.52%
NinjaMonkey, SniperMonkey, WizardMonkey 76 37 39 48.68% 0.33% 37.45%
BananaFarm, Druid, MonkeySub 329 137 192 41.64% 1.43% 36.31%
IceMonkey, MonkeyVillage, TackShooter 167 73 94 43.71% 0.73% 36.19%
GlueGunner, MortarMonkey, TackShooter 41 21 20 51.22% 0.18% 35.92%
BoomerangMonkey, NinjaMonkey, SniperMonkey 46 23 23 50.00% 0.20% 35.55%
GlueGunner, TackShooter, WizardMonkey 82 38 44 46.34% 0.36% 35.55%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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