saadiqCryptoadz
Updated 2023-11-20
999
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
33
34
35
36
›
⌄
-- forked from 408a9b27-2a8d-4a75-8c55-8990ce54acad
-- forked from 56344a48-9e73-4f66-9045-424db82efd32
-- forked from 35c312dc-9850-495f-a1c8-cf7ae731278a
-- forked from 76366238-a593-4d7b-b829-a3f1eb57d6eb
-- forked from a2aec536-44a5-4897-ba91-d3a204422855
-- forked from d74813b4-269c-4d86-b0f5-a6ec968d4aef
SELECT
sum(
CASE
WHEN contract_address IN ('0x1cb1a5e65610aeff2551a50f76a87a7d3fb649c6') THEN 1
ELSE 0
END
) AS wallets,
sum(
CASE
WHEN contract_address IN ('0x1cb1a5e65610aeff2551a50f76a87a7d3fb649c6') THEN current_bal_unadj
ELSE 0
END
) AS items,
sum(
CASE
WHEN contract_address IN (
'0x059edd72cd353df5106d2b9cc5ab83a52287ac3a',
'0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270',
'0x99a9b7c1116f9ceeb1652de04d5969cce509b069'
) THEN 1
ELSE 0
END
) AS have_artblocks,
concat(round(have_artblocks / wallets * 100, 1), '%') as perc_owning_ab,
sum(
CASE
WHEN contract_address IN ('0x23581767a106ae21c074b2276d25e5c3e136a68b') THEN 1
ELSE 0
END
) AS have_moonbirds,
Run a query to Download Data