princefarzamThe number of properties that each investor has
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH assetID AS (SELECT
ASSET_ID,
ASSET_NAME,
50 * TOTAL_SUPPLY AS total_token_investment_price -- each part valued 50 USD
FROM algorand.asset
WHERE CREATOR_ADDRESS='LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
AND TOTAL_SUPPLY <> 0
AND ASSET_ID <> 237267329 --Except loftyAI
AND ASSET_URL IS NOT NULL -- removing noises
ORDER BY 3 DESC)
SELECT
A.ADDRESS AS Investors,
COUNT(A.AMOUNT) AS The_Number_of_properties,
The_Number_of_properties*50 AS The_value_of_properties
FROM algorand.account_asset A INNER JOIN assetID ID ON A.ASSET_ID = ID.ASSET_ID
WHERE A.AMOUNT >= 1
AND A.ADDRESS <>'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA' --Excluding LoftyAI address
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10
Run a query to Download Data