princefarzamUSDT vs. USDC holders
Updated 2022-02-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH USDT_HOLDERS AS (
SELECT
COUNT(DISTINCT ADDRESS) AS NUMBER_OF_USDT_HOLDERS
FROM ALGORAND.ACCOUNT_ASSET
WHERE ASSET_ID = 312769
AND AMOUNT IS NOT NULL
),
USDC_HOLDERS AS (
SELECT
COUNT(DISTINCT ADDRESS) AS NUMBER_OF_USDC_HOLDERS
FROM ALGORAND.ACCOUNT_ASSET
WHERE ASSET_ID = 31566704
AND AMOUNT IS NOT NULL
)
SELECT
'HOLDERS',
USDT.NUMBER_OF_USDT_HOLDERS,
USDC.NUMBER_OF_USDC_HOLDERS
FROM USDT_HOLDERS USDT FULL OUTER JOIN USDC_HOLDERS USDC
Run a query to Download Data