all_maps (view)

25 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 1306 2.68% 06:36 13.93 24.16
basalt_columns 994 2.04% 05:44 11.01 25.8
bloon_bot_factory 933 1.91% 06:14 14.13 26.52
bloonstone_quarry 3031 6.21% 10:56 21.08 28.31
building_site_scene 881 1.80% 04:17 10.6 24.27
castle_ruins 1976 4.05% 07:03 15.94 26.56
cobra_command 2454 5.03% 07:19 16.51 26.59
dino_graveyard 3073 6.30% 08:30 17.18 26.22
garden 1610 3.30% 07:04 15.38 27.6
glade 1503 3.08% 06:31 13.09 25.3
inflection 1253 2.57% 05:51 11.33 25.74
koru 1636 3.35% 06:09 14.29 25.83
mayan_map_01 1272 2.61% 09:05 20.33 26.82
neo_highway 1116 2.29% 06:44 13.16 26.21
oasis 3444 7.06% 08:07 18.86 25.84
off_tide 2915 5.97% 07:27 16.56 27.0
pirate_cove 1449 2.97% 06:42 13.3 25.73
ports 892 1.83% 04:22 9.95 26.43
precious_space 1946 3.99% 07:59 16.16 25.95
salmon_pool 1650 3.38% 07:40 15.57 25.7
sands_of_time 2948 6.04% 08:05 18.38 26.42
star 3574 7.32% 09:31 19.05 26.87
sun_palace 3116 6.38% 08:04 18.92 25.6
times_up 1546 3.17% 06:55 14.47 24.56
up_on_the_roof 2296 4.70% 12:31 22.08 31.3

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