Query editor
WITH country_stats (countries) AS (SELECTt1.*FROM (SELECT split(countries, ',') AS countriesFROM dune.alexprimex.price_pulse_statisticsLIMIT 1) CROSS JOIN UNNEST(countries) AS t1(language))SELECTsplit(countries, ':')[1] AS country,CAST(LTRIM(split(countries, ':')[2]) AS int) AS usersFROM country_statsORDER BY users DESC