select *

from ( values

('Beam', 'eYwmVU67LmSfZb1RwqCMhBYkFyG8ftxn6jAwqzFmxC9STBWLC', '4337'),

('DFK', 'Vn3aX6hNRstj5VHHm63TCgPNaeGnRSqCYXQqemSqDd2TQH4qJ', '53935'),

('DOS', 'nQCwF6V9y8VFjvMuPeQVWWYn6ba75518Dpf6ZMWZNb3NyTA94', '7979'),

('Dexalot', 'wenKDikJWAYQs3f2v9JhV86fC6kHZwkFZsuUBftnmgZ4QXPnu', '432204'),

('Loco Legends', 'KfZ2YSPbKDGqJW2yiiYFYLwAu39MAt8JKQKyRzcurrKAJfff9', '262018'),

('MELD', '2ibTg9ruyJRQf4NpRbkd1Utcfayo3gRRpkoWGCWNC3oXTZoYCe', '333000333'),

('Mintara', 'T6XNCf5qHYhJigDcGtjTaGvfiQGRW8JVXTyPza9eZBfCGyDF', '1080'),

('Rymedi Identity', 'qWeo55RT2F7SNoWtVUuAGptPoz23hViLthjHHaj3BsV2pv7TM', '111001001'),

('Rymedi Transaction', 'LThVFg2aFviak8Ranf8nNX4UAEtLyzhyCNY2AQdXbgYkJdQTM', '111002001'),

('Rymedi Compliance', '2v7aLktZroWTwcSPHkN6gSDjzJCDuAsHhHpRZTMKiqnegwG6sL', '111003001'),

('Shrapnel', 'Cv1gyKNUtPNAtFw8YcjbsD4a3HNRbNvinY7t2gnGK4J54rQK3', '2044'),

('Step Network', '7f9jciLEX25NPJEaAz1X7XF44B1Q9UBwq6PdnCHm5mnUq1e1C', '1234'),

('Swimmer Network', '2e3CqLY8thW1WKS89WQ7WR9Qy2bCrrP5mv7psqMRGCHGXuQ1Uj', '73772'),

('UPTN', 'yDxaSh2hoVxQKRHmacV1xFpuSgHf6Q6cCMu4v3GoLQnqQWk6L', '6119'),

('Wraptag', 'A1iV86hr1toCL7y4F6PM263n9fomCLUDDwpqFT2sG9FTCZJCm', '24052022'),

('XPLUS', '2aa7G6cQbomnqyhBexzWPmvihio8Uk1qrzYpBRNH2wcNpBkgNU', '1228'),

('Xana', 'ii7zCu8JNnYYgPT8PwpVYiTS1gcK5RWJfsyuPXTDv8Bn9wspY', '8888')) as a (subnet_name, Subnet_ID, EVM_Chain_ID)),

get_url as (

select

*,

'https://metrics.avax.network/v1/validators/network/mainnet/subnetId/' || Subnet_ID as url

from main_data),

base1 as (

select

subnet_name,

livequery.live.udf_api(url) as resp

FROM get_url

where subnet_name = '{{First_Subnet}}')

select

subnet_name as "Subnet Name",