season_25_matches: all

24 rows

descending

Map	Games	Pickrate	Average Duration	Average End Round	Seconds per Round
banana_depot_scene	1285	2.46%	06:46	14.41	24.07
basalt_columns	1079	2.06%	05:58	11.79	25.33
bloon_bot_factory	943	1.80%	07:48	15.07	27.09
bloonstone_quarry	3456	6.61%	10:07	22.02	27.59
building_site_scene	863	1.65%	04:24	10.97	24.14
castle_ruins	2157	4.12%	07:17	16.51	26.48
cobra_command	2758	5.27%	08:10	17.72	27.65
dino_graveyard	3186	6.09%	08:00	18.0	26.69
garden	1919	3.67%	08:58	16.18	29.56
glade	1483	2.83%	06:47	13.65	25.46
inflection	1396	2.67%	05:57	11.64	25.57
koru	1774	3.39%	06:43	14.33	23.97
mayan_map_01	1443	2.76%	09:27	21.02	26.98
oasis	3706	7.08%	09:55	20.05	26.73
off_tide	3312	6.33%	08:39	17.8	25.8
pirate_cove	1267	2.42%	06:31	13.09	25.3
ports	1037	1.98%	05:08	10.27	30.03
precious_space	2111	4.03%	07:00	16.72	25.15
salmon_pool	1777	3.40%	07:03	16.06	26.37
sands_of_time	3390	6.48%	09:04	19.92	27.34
star	4217	8.06%	10:33	19.91	28.79
sun_palace	3600	6.88%	08:29	19.72	25.84
times_up	1342	2.57%	06:46	14.1	24.56
up_on_the_roof	2817	5.38%	12:13	22.99	31.89

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW all_maps AS 
WITH elite_maps AS (
    SELECT map, duration, endRound
    FROM matches
    WHERE map NOT IN ('bloontonium_mines', 'docks', 'in_the_wall', 'island_base', 'thin_ice')
)
SELECT map AS Map,
       Games,
       printf('%.2f%%', Games * 100.0 / (SELECT COUNT(*) FROM elite_maps)) AS Pickrate,
       REPLACE((CASE
                    WHEN CAST(ROUND(avg_duration / 60, 0) AS INTEGER) < 10
                        THEN '0' || CAST(ROUND(avg_duration / 60, 0) AS TEXT)
                    ELSE CAST(ROUND(avg_duration / 60, 0) AS TEXT)
           END) || ':' ||
               (CASE
                    WHEN CAST(ROUND(avg_duration % 60, 0) AS INTEGER) < 10
                        THEN '0' || CAST(ROUND(avg_duration % 60, 0) AS TEXT)
                    ELSE CAST(ROUND(avg_duration % 60, 0) AS TEXT)
                   END), '.0', '')                                 AS [Average Duration],
       ROUND(avg_end_round, 2)                                     AS [Average End Round],
       ROUND(avg_duration / avg_end_round, 2)                      AS [Seconds per Round]
FROM (SELECT map,
             AVG(duration) AS avg_duration,
             AVG(endRound) AS avg_end_round,
             COUNT(*)      AS Games
      FROM elite_maps
      GROUP BY map);

all_maps (view)

24 rows

Advanced export