MetiocreFig 8. Top 10 Highest Al-Goanna sales
    Updated 2022-05-26
    with goanas as (
    select *
    from
    flipside_prod_db.algorand.asset
    where creator_address='D5J7H7PIYKLY2U6A5OFUAC7GQHTHSXXNX65DSD3CJYPBV2MVK6NTNW44CA'
    and asset_name ILIKE 'AL Goanna%'
    ),
    sale_tx_groups as (
    select distinct tx_group_id,
    asset_id
    from
    algorand.transfers as t
    join goanas using(asset_id)
    )

    select pt.tx_group_id,
    sale_tx_groups.asset_id,
    pt.sender,
    pt.receiver,
    pt.amount,
    row_number() over (order by pt.amount desc) as rank
    from
    algorand.payment_transaction as pt
    join sale_tx_groups on pt.tx_group_id = sale_tx_groups.tx_group_id
    where
    pt.asset_id=0
    and pt.amount > 0
    qualify rank <= 10
    Run a query to Download Data