select distinct
'0x' || substring(topics[2], 27, 67) as gg,count(distinct
'0x' || substring(topics[1], 27, 67)) as zz
from
blast.core.fact_event_logs
WHERE
TOPICS[0] = '0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925'
/* and CONTRACT_ADDRESS = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8'*/
GROUP by gg HAVING zz > 100