case when project_name ilike '%astroport%' then 'Astroport' when project_name ilike '%valkyrie%' then 'valkyrie' else project_name end as "Contract Name",

count(*) as "Count"

from terra.core.fact_transactions left join terra.core.dim_address_labels on tx:body:messages[0]:contract = address

where

tx_succeeded = 'TRUE' and

"Contract Name" is not null

group by 1 having "Count" > 100