rackhaelFLOW
Updated 2023-06-03
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT DISTINCT nft_collection,
CASE WHEN nft_collection = 'A.0b2a3299cc857e29.TopShot' THEN topshot
WHEN nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
WHEN nft_collection = 'A.329feb3ab062d289.UFC_NFT'
WHEN nft_collection = 'A.e4cf4bdc1751c65d.PackNFT'
WHEN nft_collection = 'A.eee6bdee2b2bdfc8.Basketballs'
count(tx_id) as sales
FROM flow.core.ez_nft_sales
group by 1
order by 2 desc
-- WHERE
Run a query to Download Data