SELECT 'Solo Leveling L1 Space' AS chain_name, '8227' AS chain_id

UNION ALL SELECT 'DFK (DeFi Kingdoms)', '53935'

UNION ALL SELECT 'Blitz', '1344'

UNION ALL SELECT 'PLAYA3ULL GAMES', '3011'

UNION ALL SELECT 'Playdapp Network', '504441'

UNION ALL SELECT 'Pulsar', '357'

UNION ALL SELECT 'Shrapnel', '2044'

UNION ALL SELECT 'Solert Games', '9899'

UNION ALL SELECT 'Swimmer Network', '73772'

UNION ALL SELECT 'Tiltyard', '710420'

UNION ALL SELECT 'Xana', '8888'

UNION ALL SELECT 'MUGEN', '29111'

UNION ALL SELECT 'OMOCHI', '5041'

UNION ALL SELECT 'ONIGIRI', '5040'

UNION ALL SELECT 'HighOctane', '1853'

UNION ALL SELECT 'Step Network', '1234'

UNION ALL SELECT 'XPLUS', '1228'

UNION ALL SELECT 'Teleporter1', '62707'

UNION ALL SELECT 'Teleporter2', '70953'

UNION ALL SELECT 'Lamina1', '10849'

UNION ALL SELECT 'Lamina1 Identity', '10850'

UNION ALL SELECT 'PLYR PHI', '16180'

UNION ALL SELECT 'GUNZ (Off the Grid)', '49321'

),

MaxTPSData AS (

SELECT

c.chain_name,

c.chain_id,

live.udf_api('https://metrics.avax.network/v1/max_tps/' || c.chain_id || '?timeInterval=day') AS response

FROM Chains c

),

ParsedMaxTPS AS (

SELECT