alirsLofty 12
    Updated 2022-07-15
    with assets as (
    SELECT
    asset_name, asset_id
    FROM algorand.asset
    WHERE creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    AND asset_deleted != 'TRUE'
    AND asset_name != 'Lofty AI'
    )
    SELECT
    count(DISTINCT att.asset_receiver) as unique_wallets_count,
    count(att.asset_receiver) as wallets_count,
    att.asset_id,
    assets.asset_name
    from algorand.asset_transfer_transaction att join assets on att.asset_id = assets.asset_id
    where att.asset_id in (select asset_id from assets)
    group by 3,4
    order by 1,2
    Run a query to Download Data