Pmisha-bmlMdxPopular projects
Updated 2022-06-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with t1 as (select
ASSET_ID,
ASSET_NAME
from flipside_prod_db.algorand.asset
where ASSET_NAME ilike '%nft%'
)
select
b.ASSET_NAME as project,
count(distinct s.TX_ID) as application
from flipside_prod_db.algorand.ASSET_TRANSFER_TRANSACTION s left outer join algorand.asset b on s.ASSET_ID=b.ASSET_ID
where s.ASSET_ID in (select ASSET_ID from t1)
group by 1
order by 2 desc
limit 10
Run a query to Download Data