Query editor
WITH leaderboard_data AS (SELECTjson_parse(HTTP_GET('https://relayer.ambire.com/legends/leaderboard?pageSize=1000000')) AS leaderboard_json),entries AS (SELECT entryFROM leaderboard_dataCROSS JOIN UNNEST(CAST(json_extract(leaderboard_json, '$.season1Leaderboard.entries') AS ARRAY(JSON))) AS t(entry))SELECTCAST(json_extract_scalar(entry, '$.level') AS INTEGER) AS level,CAST(json_extract_scalar(entry, '$.xp') AS INTEGER) AS xp,json_extract_scalar(entry, '$.account') AS account,CAST(json_extract_scalar(entry, '$.rank') AS INTEGER) AS rank,CAST(json_extract_scalar(entry, '$.projectedRewards') AS DOUBLE) AS projectedRewards,CAST(json_extract_scalar(entry, '$.projectedRewards') AS DOUBLE)/CAST(json_extract_scalar(entry, '$.xp') AS INTEGER) as TokensPerXpFROM entries;