WITH Delegate AS (

SELECT

tx_id,

instruction.value:parsed.info.amount / 1e9 AS Adjusted_amount,

CASE

WHEN instruction.value:parsed.info.mint = 'sonickAJFiVLcYXx25X9vpF293udaWqDMUCiGtk7dg2' THEN 'Sonic'

WHEN instruction.value:parsed.info.mint = 'hash4eTHsuZakZiHg5vfQwFtBaEhhC9SXRYsZm4Br7k' THEN 'HashKey Cloud'

WHEN instruction.value:parsed.info.mint = 'bonkABCQVasnhyVAvB2zYFSCRMGB6xKhpthKuCnsU5K' THEN 'BONK'

WHEN instruction.value:parsed.info.mint = '6C41vb9AqJzmbWZ4zi6eCGJz3vSKrwjxfu8N77SRRtyr' THEN 'AltLayer'

ELSE 'Unknown'

END AS Validator_Name

FROM

solana.core.fact_events s,

TABLE(FLATTEN(input => INNER_INSTRUCTION:instructions)) AS instruction

WHERE

program_id = 'endoLNCKTqDn8gSVnN2hDdpgACUPWHZTwoYnnMybpAT'

AND instruction.value:parsed.type::STRING = 'burn'

AND BLOCK_TIMESTAMP::date >= '2024-08-14'

AND SUCCEEDED = 'TRUE'

-- AND tx_id = '2JFUnwaW9a5q7doVxfN3nFj8imWEF4jBk6hxcU6t8TjGe3fbXrfRPtbPXh5rTWDmwAzPuudoPeTrFjoPjxgwobGe'

SELECT

Validator_Name,

COUNT(DISTINCT tx_id) AS Total_Transactions

FROM

Delegate

WHERE Validator_Name != 'Unknown'

GROUP BY