ErsvanMona Lisa- Lil Pump ft Soulja Boy MFT - General
Updated 2022-05-26
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
25
26
27
28
29
30
31
32
›
⌄
⌄
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
/*
SELECT
*
FROM
algorand.account_asset
WHERE
address = 'ISSY3W2SLS3S5NHLUH3G77PH6SCBQ5ZTZ22ZCIPXGB26ESHYP32MELSMU4'
*/
Run a query to Download Data