with moonfun AS (

SELECT tx_id, instruction:parsed:info:mintAuthority AS creator,

instruction:parsed:info:mint AS token,

instruction:parsed:info:amount / 1e9 AS amounts

FROM eclipse.core.fact_events

WHERE tx_id IN (SELECT tx_id

FROM eclipse.core.fact_events_inner

WHERE event_type = 'initializeImmutableOwner'

and instruction_program_id = 'F3MQq5eugYvhUJqnRruvyv3tu7nsVBgXxJrsaKfLhRDL'

AND program_id = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'

AND instruction:parsed:type = 'mintTo'

AND instruction:parsed:info:amount = '1000000000000000000'

and block_timestamp >= '2024-11-18'

AND succeeded = 'TRUE'

SELECT creator,

COUNT(tx_id) AS mint_count

FROM moonfun

GROUP BY creator

ORDER BY mint_count DESC