ErsvanMona Lisa- Lil Pump ft Soulja Boy MFT - Send by address
Updated 2022-05-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
WITH w_amount_transfer (address,action_name,NUM_ACTION,AMOUNT_TOTAL) AS
(
SELECT
algorand.asset_transfer_transaction.sender AS address, 'SEND' AS action_name,COUNT(*) AS NUM_ACTION, SUM(ASSET_AMOUNT) AS AMOUNT_TOTAL_ACTION
FROM
algorand.asset_transfer_transaction
WHERE
ASSET_ID = 725937713
AND ASSET_AMOUNT != 0
GROUP BY algorand.asset_transfer_transaction.sender
UNION ALL
SELECT
algorand.asset_transfer_transaction.asset_receiver AS address, 'RECEIVER' AS action_name, COUNT(*) AS NUM_ACTION, SUM(ASSET_AMOUNT) AS AMOUNT_TOTAL
FROM
algorand.asset_transfer_transaction
WHERE
ASSET_ID = 725937713
AND ASSET_AMOUNT != 0
GROUP BY algorand.asset_transfer_transaction.asset_receiver
)
SELECT * FROM w_amount_transfer WHERE action_name = 'SEND'
Run a query to Download Data