PapasotGardian airdrop & staking overlap
    Updated 2023-01-03
    with gardian_airdrops as(
    SELECT
    asset_receiver,
    asset_amount as Gardian_airdrop_rewards
    from algorand.asset_transfer_transaction
    where sender = 'B7YLKLF7FGTURCSGOPO2GHTLEQKXEQHVTIMFOZWBYUY55RDGTADQDS3ICI'
    and asset_transferred = '692432647'
    and block_timestamp > '2022-05-06'
    and block_timestamp < '2022-05-08'
    )

    SELECT
    count(b.sender) as staking_airdrop_overlap

    from algorand.asset_transfer_transaction b
    left join gardian_airdrops a on a.asset_receiver = b.sender

    where b.asset_receiver = '4ZK3UPFRJ643ETWSWZ4YJXH3LQTL2FUEI6CIT7HEOVZL6JOECVRMPP34CY'
    and b.asset_transferred = '684649988'
    and b.sender = a.asset_receiver
    Run a query to Download Data