binhachonALGOxNFT Marketplace - #4
Updated 2022-05-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tx_group_id as (
select
distinct
sender as sender_0,
tx_group_id as tx_group_id_0
from algorand.payment_transaction
where receiver = 'XNFT36FUCFRR6CK675FW4BEBCCCOJ4HOSMGCN6J2W6ZMB34KM2ENTNQCP4'
and amount > 0
),
stats as (
select
distinct
tx_group_id,
asset_transferred
from algorand.asset_transfer_transaction
inner join tx_group_id on (tx_group_id = tx_group_id_0 and asset_receiver = sender_0)
)
select
count(distinct asset_transferred) as number_of_unique_NFTs
from stats
Run a query to Download Data