lagandispenserTop 20 used applications in the last 6 months
    Updated 2022-06-30
    select c.address_name, count(distinct a.sender) as number_of_users
    from flipside_prod_db.algorand.application_call_transaction a join flipside_prod_db.algorand.account_app b on a.app_id = b.app_id
    join flipside_prod_db.algorand.labels c on b.address = c.address where a.block_timestamp >= '2021-07-01'
    and a.block_timestamp <= '2021-12-31' group by 1 order by 2 desc limit 20
    Run a query to Download Data