bloonstone_quarry_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 2640 1602 1038 60.68% 5.08% 58.82%
Jericho 3182 1855 1327 58.30% 6.12% 56.58%
Churchill_Sentai 1921 1039 882 54.09% 3.70% 51.86%
Bonnie 11588 6020 5568 51.95% 22.30% 51.04%
Jericho_StarCaptain 623 338 285 54.25% 1.20% 50.34%
Obyn 1605 830 775 51.71% 3.09% 49.27%
Benjamin 2082 1062 1020 51.01% 4.01% 48.86%
Ezili_SmudgeCat 329 178 151 54.10% 0.63% 48.72%
Ezili 1034 529 505 51.16% 1.99% 48.11%
StrikerJones 519 269 250 51.83% 1.00% 47.53%
Etienne_Bee 3266 1579 1687 48.35% 6.28% 46.63%
Gwendolin_Science 2685 1292 1393 48.12% 5.17% 46.23%
Adora 1888 901 987 47.72% 3.63% 45.47%
Quincy_Cyber 1991 945 1046 47.46% 3.83% 45.27%
Obyn_Ocean 1298 615 683 47.38% 2.50% 44.66%
Etienne 6436 2913 3523 45.26% 12.38% 44.04%
Quincy 2391 1098 1293 45.92% 4.60% 43.92%
Jericho_Highwayman 630 300 330 47.62% 1.21% 43.72%
Gwendolin 2254 1027 1227 45.56% 4.34% 43.51%
Adora_Fateweaver 290 142 148 48.97% 0.56% 43.21%
StrikerJones_Biker 670 314 356 46.87% 1.29% 43.09%
PatFusty 669 309 360 46.19% 1.29% 42.41%
Churchill 1422 593 829 41.70% 2.74% 39.14%
Benjamin_DJ 557 235 322 42.19% 1.07% 38.09%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW bloonstone_quarry_heroes AS 
WITH bloonstone_quarry AS
    (SELECT *
    FROM matches
    WHERE map = 'bloonstone_quarry')
SELECT Hero,
       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 Hero,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM bloonstone_quarry) * 2)    AS PR
      FROM (SELECT Hero,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT lHero             AS Hero,
                         playerLeftWin     AS Win
                  FROM bloonstone_quarry
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM bloonstone_quarry)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;