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 1508 2.65% 06:55 14.6 24.34
basalt_columns 1135 2.00% 05:56 11.28 26.26
bloon_bot_factory 1031 1.81% 06:20 14.28 26.62
bloonstone_quarry 3594 6.32% 10:56 21.6 27.62
building_site_scene 959 1.69% 04:21 10.79 24.28
castle_ruins 2320 4.08% 07:16 16.53 26.41
cobra_command 2955 5.20% 08:39 17.28 26.58
dino_graveyard 3481 6.12% 08:47 17.67 26.45
garden 2006 3.53% 07:03 15.36 27.55
glade 1661 2.92% 06:00 13.23 27.25
inflection 1592 2.80% 05:54 11.49 25.64
koru 1895 3.33% 06:41 14.3 23.87
mayan_map_01 1553 2.73% 09:08 20.44 26.84
neo_highway 619 1.09% 05:25 12.2 26.69
oasis 4021 7.07% 08:24 19.44 25.96
off_tide 3404 5.99% 07:07 16.88 25.35
pirate_cove 1437 2.53% 05:29 13.0 25.38
ports 1042 1.83% 05:02 10.08 30.0
precious_space 2324 4.09% 07:09 16.32 26.3
salmon_pool 1999 3.52% 07:45 15.69 25.84
sands_of_time 3625 6.38% 09:35 19.34 26.64
star 4419 7.77% 09:52 19.58 27.17
sun_palace 3724 6.55% 09:38 19.32 26.85
times_up 1670 2.94% 06:51 14.58 24.12
up_on_the_roof 2882 5.07% 12:10 22.85 31.99

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