contract_count_category,

COUNT(origin_from_address) AS address_count

FROM (

SELECT

origin_from_address,

COUNT(DISTINCT contract_address) AS distinct_contract_count,

CASE

WHEN COUNT(DISTINCT contract_address) = 1 THEN '1 contract'

WHEN COUNT(DISTINCT contract_address) BETWEEN 2 AND 5 THEN '2-5 contracts'

WHEN COUNT(DISTINCT contract_address) BETWEEN 6 AND 10 THEN '6-10 contracts'

WHEN COUNT(DISTINCT contract_address) BETWEEN 11 AND 20 THEN '11-20 contracts'

ELSE 'More than 20 contracts'

END AS contract_count_category

FROM

sei.core_evm.fact_event_logs

GROUP BY

origin_from_address

) AS categorized

GROUP BY

contract_count_category;