post_upgrade AS (

SELECT

el.origin_to_address AS contract_address,

COALESCE(dl.project_name, 'Unknown') AS project_name,

COUNT(*) AS post_upgrade_interactions

FROM avalanche.core.fact_event_logs el

LEFT JOIN avalanche.core.dim_labels dl

ON el.origin_to_address = dl.address

WHERE el.block_timestamp >= DATE '2024-12-16'

AND el.block_timestamp < DATE '2024-12-23'

GROUP BY 1, 2

SELECT

contract_address,

project_name,

post_upgrade_interactions

FROM post_upgrade

ORDER BY post_upgrade_interactions DESC

LIMIT 10