where label = 'anchor' or label = 'mirror' or label = 'pylon'

or label = 'astroport'),

base as (select

*, case when msg_value:contract = 'terra1angxk38zehp0k09m0wqrrxf0r3ces6qjj432l8' then 'prism' -- forge -- https://finder.extraterrestrial.money/mainnet/projects/Prism

when msg_value:contract = 'terra1fyyq65sfltsnj53jdfsf6dammdfhjnelt9eh72' then 'prism' -- vesting

when msg_value:contract = 'terra1h4al753uvwmhxwhn2dlvm9gfk0jkf52xqasmq2' then 'prism' -- gov

when msg_value:contract = 'terra1xw3h7jsmxvh6zse74e4099c6gl03fnmxpep76h' then 'prism' -- luna vault

when msg_value:contract = 'terra1p7jp8vlt57cf8qwazjg58qngwvarmszsamzaru' then 'prism' -- yluna stake

when msg_value:contract = 'terra1u600u35p84fntlk5cnwvy373s2qzk903qnsdyf' then 'prism' -- airdrop

when msg_value:contract = 'terra1yxgq5y6mw30xy9mmvz9mllneddy9jaxndrphvk' then 'prism' -- cluna lp

when msg_value:contract = 'terra1persuahr6f8fm6nyup0xjc7aveaur89nwgs5vs' then 'prism' -- pluna lp

when msg_value:contract = 'terra1kqc65n5060rtvcgcktsxycdt2a4r67q2zlvhce' then 'prism' -- yluna lp

when msg_value:contract = 'terra1r38qlqt69lez4nja5h56qwf4drzjpnu8gz04jd' then 'prism' -- yluna lp

when msg_value:contract = 'terra1n38982txtv2yygtcfv3e9wp2ktmjyxl6z88rma' then 'mars' -- mars lockdrop

when msg_value:contract = 'terra1hgyamk2kcy3stqx82wrnsklw9aq7rask5dxfds' then 'mars' -- mars lppair lockdrop

end as lbl , case when label is NULL then lbl else label end as contract_name

from terra.msgs

left join labels

on msg_value:contract = address )

SELECT contract_name, count(*) as total_calls, count(DISTINCT msg_value:sender ) as unique_senders,

total_calls/ unique_senders as calls_per_sender

from base

where block_timestamp > CURRENT_DATE -90

and contract_name is not NULL

GROUP by 1

order by calls_per_sender desc

limit 100