season_32_matches: all

26 rows

descending

Map	Games	Pickrate	Average Duration	Average End Round	Seconds per Round
banana_depot_scene	346	2.66%	06:54	14.96	23.7
basalt_columns	251	1.93%	05:46	11.18	25.65
bloon_bot_factory	222	1.71%	07:00	15.24	27.59
bloonstone_quarry	804	6.19%	09:09	20.34	27.0
building_site_scene	272	2.09%	05:33	11.46	23.86
castle_ruins	565	4.35%	07:46	15.77	25.77
cobra_command	653	5.03%	07:30	14.83	26.33
dino_graveyard	715	5.50%	07:25	17.05	26.12
garden	426	3.28%	07:36	14.71	26.96
glade	431	3.32%	05:15	12.51	25.19
inflection	361	2.78%	05:42	10.9	25.93
koru	540	4.16%	06:36	14.17	23.73
mayan_map_01	196	1.51%	09:35	19.79	26.07
neo_highway	352	2.71%	06:54	13.64	26.02
oasis	927	7.13%	08:56	18.61	25.59
off_tide	852	6.56%	07:35	16.14	24.51
pirate_cove	430	3.31%	06:37	13.55	24.9
ports	255	1.96%	05:54	11.54	25.5
precious_space	543	4.18%	06:17	15.21	24.85
salmon_pool	380	2.92%	06:13	14.6	25.55
sands_of_time	743	5.72%	08:47	17.95	26.04
splashdown	348	2.68%	06:11	14.55	25.54
star	1030	7.93%	08:12	18.65	26.43
sun_palace	811	6.24%	07:22	17.77	24.89
times_up	360	2.77%	05:20	13.34	24.0
up_on_the_roof	181	1.39%	12:05	23.55	30.83

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)

26 rows

Advanced export