ORIGIN_FROM_ADDRESS as top_drillhouse_minters,

count (*) as number_of_mints,

-- 'Drill_Club' as nft_category,

case when origin_to_address = '{{Seiyans}}' then 'Seiyans'

when origin_to_address = '{{Drill_Club}}' then 'Drill Club'

end as Collection

-- concat('nft 2: ', Collection ) as Collection

FROM sei.core_evm.fact_event_logs

WHERE block_timestamp >= '2025-01-01'

AND origin_to_address='{{Drill_Club}}' and tx_status='SUCCESS'

group by all

qualify row_number() over (order by number_of_mints desc) <= 10