MLDZMNloft2
    Updated 2022-07-14
    with tb1 as (SELECT
    address as wl,
    count(wl) as no_participate
    FROM algorand.account_asset
    WHERE asset_id IN (SELECT asset_id FROM algorand.asset
    WHERE creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA')
    AND asset_name != 'Lofty AI'
    AND asset_closed = 'FALSE'
    group by 1)

    select
    *
    from tb1
    where wl != 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    order by 2 desc
    limit 20
    Run a query to Download Data