tkvresearch2024-03-12 05:51 PM
Updated 2024-03-12
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
›
⌄
/* BNB CodeConqueror address: 0x87a218ae43c136b3148a45ea1a282517794002c8 */
/* BNB PixelProwler address: 0x45eb7e752e446db7e7c757b21b26cbc897345843 */
/* BNB MelodyMaven address: 0x917b43b57d25952c1a8ce1af68aec95678d1246e */
/* BNB EcoGuardian address: 0x1d143f26540c4bf893d74bef4a5d9999987e492b */
/* Polygon CodeConqueror address: 0xe7c224ec925e877659ffbab6d44bdf0413135c51 */
/* Polygon PixelProwler address: 0x141a1fb33683c304da7c3fe6fc6a49b5c0c2dc42 */
/* Polygon MelodyMaven address: 0x20fb7ec336958ea887a288ce49999d7d7c08529c */
/* Polygon EcoGuardian address: 0x9d03ab31c0e71d909c68d3f6bb7483577ba8dcd7 */
with
L AS ( select * from (VALUES
( 'BNB','CodeConqueror','0x87a218ae43c136b3148a45ea1a282517794002c8'),
( 'BNB','PixelProwler','0x45eb7e752e446db7e7c757b21b26cbc897345843'),
( 'BNB','MelodyMaven','0x917b43b57d25952c1a8ce1af68aec95678d1246e'),
( 'BNB','EcoGuardian','0x1d143f26540c4bf893d74bef4a5d9999987e492b'),
( 'Polygon','CodeConqueror','0xe7c224ec925e877659ffbab6d44bdf0413135c51'),
( 'Polygon','PixelProwler','0x141a1fb33683c304da7c3fe6fc6a49b5c0c2dc42'),
( 'Polygon','MelodyMaven','0x20fb7ec336958ea887a288ce49999d7d7c08529c'),
( 'Polygon','EcoGuardian','0x9d03ab31c0e71d909c68d3f6bb7483577ba8dcd7')
) as l1(chain, nft_name, address)),
final_table as
(select nft_to_address as nft_holder,
nft_label_name,
sum(nft_cnt) as number_nft_holding
from
(select nft_to_address,
nft_label_name,
sum(nft_count) as nft_cnt
from
(select
NFT_TO_ADDRESS,
case
when nft_address = '0x87a218ae43c136b3148a45ea1a282517794002c8' then 'CodeConqueror'
QueryRunArchived: QueryRun has been archived