tongzzezDegen Apes nft data
Updated 2022-10-10
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
›
⌄
-- with nft_info as(
select
case
when token_metadata:Clothing ilike '%bowling shirt%' then 'Bowling'
when token_metadata:Clothing ilike '%ski jacket%' then 'Ski'
when token_metadata:Clothing ilike '%nb-ape%' then 'Basketball'
else 'Not Sport' END as type,
token_metadata:Clothing as clothes,
count(1) as number_type
from
solana.core.dim_nft_metadata
where 1=1
and contract_name = 'Degen Apes'
and contract_address <> 'DC2mkgwhy56w3viNtHDjJQmc7SGu2QX785bS4aexojwX'
group by
type, clothes
-- beast mode -- rugby
-- freak -- rugby
-- goat -- bas
-- golf -- golf
-- la pulga kit -- football
-- mamba -- bas
-- the king kit -- football
-- )
-- select
Run a query to Download Data