sarathMonalisa part1
Updated 2022-05-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
WITH share AS (SELECT address, sum(amount) as shares
FROM algorand.account_asset
WHERE asset_id = '725937713'
GROUP by address),
calim AS (SELECT DISTINCT receiver,sum( amount) as amount
FROM algorand.transfers
WHERE tx_sender = 'ISSY3W2SLS3S5NHLUH3G77PH6SCBQ5ZTZ22ZCIPXGB26ESHYP32MELSMU4' AND asset_id = '725937713'
GROUP by receiver)
SELECT *
FROM share LEFT JOIN calim on address = receiver
WHERE shares = amount
Run a query to Download Data