ramishoowUntitled Query
Updated 2023-01-05
9
1
2
3
4
5
6
7
›
⌄
with ramishoow as (select distinct message_value:contract as "Contract Address", count(distinct tx_id) as "Times Deployed" from terra.core.ez_messages where message_type like '%Contract%' group by 1 ) select case
--with ramishoow as (select distinct message_value:contract as "Contract Address", count(distinct tx_id) as "Times Deployed" from terra.core.ez_messages where message_type like '%Contract%' group by 1 ) select case
when "Times Deployed" = 0 then '0 Times Deployed' when "Times Deployed" between 1 and 10 then 'a 1 to 10 Times Deployed'
when "Times Deployed" between 11 and 50 then 'b 11 to 50 Times Deployed' when "Times Deployed" between 51 and 100 then 'c 51 to 100 Times Deployed'
when "Times Deployed" between 101 and 500 then 'd 101 to 500 Times Deployed' when "Times Deployed" between 501 and 1000 then 'e 501 to 1,000 Times Deployed'
when "Times Deployed" between 1001 and 5000 then 'f 1,001 to 5,000 Times Deployed' when "Times Deployed" between 5001 and 10000 then 'g 5,001 to 10,000 Times Deployed'
else 'h More than 10,001 Times Deployed' end as "Type", count(distinct "Contract Address") as "Contracts Deployed" from ramishoow group by 1--ramishoow
Run a query to Download Data