SELECT

tx_hash AS tx

, origin_from_address AS add

, split_part(

split_part(

split_part(CAST(decoded_log AS VARCHAR), '.base.eth', 1)

, 'name":"', 2)

, '","node', 1

) AS BaseName

FROM base.core.ez_decoded_event_logs

WHERE 1=1

AND contract_address = lower('0xc6d566a56a1aff6508b41f6c90ff131615583bcd')

AND event_name = 'NameChanged'

CASE WHEN name_count = 1 THEN '1'

WHEN name_count = 2 THEN '2'

WHEN name_count >= 3 AND name_count <= 5 THEN '3 to 5'

WHEN name_count >= 6 AND name_count <= 10 THEN '6 to 10'

WHEN name_count >= 11 AND name_count <= 20 THEN '11 to 20'

WHEN name_count >= 21 AND name_count <= 50 THEN '21 to 50'

WHEN name_count >= 51 AND name_count <= 100 THEN '51 to 100'

WHEN name_count >= 101 AND name_count <= 200 THEN '101 to 200'

WHEN name_count >= 201 AND name_count <= 500 THEN '200 to 500'

ELSE 'More than 500' END AS No_Of_Mint_Per_Wallet

, COUNT(DISTINCT add) AS Address

FROM (

SELECT

add

, count(DISTINCT basename) AS Name_count

FROM names