lagandispenserTop 20 used applications in the first 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 >= '2022-01-01'
    and a.block_timestamp <= current_date
    group by 1 order by 2 desc limit 20
    Run a query to Download Data