intellidegentUntitled Query
    Updated 2022-11-25
    select
    count(distinct(blockchain)),
    count(distinct(address)),
    count(distinct(creator)),
    count(distinct(label_type)),
    count(distinct(label_subtype)),
    count(distinct(label)),
    count(distinct(project_name))
    from terra.core.dim_address_labels;

    select * from terra.core.dim_address_labels;

    select to_char(count(distinct(tx_sender)),'fm999G999') as "Unique Addresses"
    from terra.core.fact_transactions;


    select
    dal.label,
    ftx.tx_sender,
    to_char(count(tx_id),'fm999G999') as Transactions
    from terra.core.fact_transactions ftx
    left join terra.core.dim_address_labels dal on ftx.tx_sender = dal.address
    group by
    dal.label,
    ftx.tx_sender
    order by count(tx_id) desc;


    select
    'EZ Transfers - Sender' as Type,
    dal.label,
    ezt.sender,
    to_char(count(ezt.tx_id),'fm999G999') as Transactions
    from terra.core.ez_transfers ezt
    inner join terra.core.dim_address_labels dal on ezt.sender = dal.address
    group by
    Run a query to Download Data