case when ADDRESS_NAME is not null then ADDRESS_NAME

when ADDRESS_NAME is null then CONTRACT_ADDRESS

end as contract,

count(ORIGIN_FROM_ADDRESS) as no_users

from gnosis.core.fact_event_logs s left join gnosis.core.dim_labels b on s.CONTRACT_ADDRESS=b.address

where block_timestamp >= current_date - 30

group by 1

order by 2 desc limit 10