Popular Contracts

This query returns the top 10 popular contracts

select initcap(replace(split_part(contract_call_contract_id,'.',2),'-',' ')) as contract, count(*) from transactions 
  where status = 1
  and contract_call_contract_id is not null
   group by 1
   order by 2 desc limit 10