headitmanagerTotal users who have used MIRROR
    Updated 2022-03-07
    with tbl1 as
    (
    select distinct tx_from[0] as all_address from terra.transactions where
    date(block_timestamp) <= DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null
    )
    ,tbl2 as
    (
    select distinct tx_from[0] as new_address from terra.transactions where
    date(block_timestamp) > DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null
    )
    ,tbl3 as
    (select new_address from tbl2 left join tbl1 on tbl2.new_address=tbl1.all_address where all_address is null
    )

    select count(distinct msg_value:sender) as users ,
    (
    case
    WHEN msg_value:contract='terra1wh39swv7nq36pnefnupttm2nr96kz7jjddyt2x' then 'Governance'
    WHEN msg_value:contract='terra1mzj9nsxx0lxlaxnekleqdy8xnyw2qrh3uz6h8p' then 'Factory'
    WHEN msg_value:contract='terra1t6xe0txzywdg85n6k8c960cuwgh6l8esw6lau9' then 'Oracle'
    WHEN msg_value:contract='terra1wfz7h3aqf4cjmjcvc6s8lxdhh7k30nkczyf0mj' then 'Mint'
    WHEN msg_value:contract='terra17f7zu97865jmknk7p2glqvxzhduk78772ezac5' then 'Staking'
    WHEN msg_value:contract='terra1s4fllut0e6vw0k3fxsg4fs6fm2ad6hn0prqp3s' then 'Collector'
    WHEN msg_value:contract='terra1x35fvy3sy47drd3qs288sm47fjzjnksuwpyl9k' then 'Community'
    WHEN msg_value:contract='terra1kalp2knjm4cs3f59ukr4hdhuuncp648eqrgshw' then 'Airdrop'
    WHEN msg_value:contract='terra1zpr8tq3ts96mthcdkukmqq4y9lhw0ycevsnw89' then 'Limit Order'
    WHEN msg_value:contract='terra1pmlh0j5gpzh2wsmyd3cuk39cgh2gfwk6h5wy9j' then 'Collateral Oracle'
    WHEN msg_value:contract='terra16mlzdwqq5qs6a23250lq0fftke8v80sapc5kye' then 'Short Reward'
    WHEN msg_value:contract='terra1mwshjfdth2xtpx7gvnwpzhks2clr9z7h9m0e0f' then 'Band Oracle'

    end
    ) as projects
    from terra.msgs
    where
    (
    msg_value:contract in
    Run a query to Download Data