all_maps (view)

26 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Map Games Pickrate Average Duration Average End Round Seconds per Round
banana_depot_scene 1262 2.45% 06:43 14.41 23.84
basalt_columns 1007 1.96% 05:49 11.36 25.51
bloon_bot_factory 936 1.82% 06:14 14.04 26.64
bloonstone_quarry 3138 6.10% 09:06 20.11 27.18
building_site_scene 931 1.81% 04:18 10.77 24.03
castle_ruins 2163 4.20% 07:39 15.33 26.08
cobra_command 2402 4.67% 07:07 16.27 26.29
dino_graveyard 3400 6.60% 08:37 16.84 27.16
garden 1584 3.08% 07:44 14.63 27.66
glade 1523 2.96% 05:29 12.6 26.17
inflection 1225 2.38% 05:38 10.8 25.81
koru 2021 3.93% 06:02 14.38 25.18
mayan_map_01 1405 2.73% 08:27 19.46 26.1
neo_highway 1193 2.32% 06:46 13.19 26.27
oasis 3670 7.13% 07:28 17.78 25.23
off_tide 3162 6.14% 07:36 16.08 24.69
pirate_cove 1689 3.28% 06:35 13.22 25.34
ports 956 1.86% 04:28 10.62 25.3
precious_space 2062 4.01% 06:26 15.55 24.82
salmon_pool 1559 3.03% 06:01 14.09 25.64
sands_of_time 3060 5.94% 08:49 18.02 26.05
splashdown 1462 2.84% 06:15 14.5 25.88
star 3915 7.61% 08:52 17.96 26.31
sun_palace 3344 6.50% 08:41 18.29 25.23
times_up 1241 2.41% 05:15 13.11 24.07
up_on_the_roof 1167 2.27% 11:43 21.34 30.16

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);