with shrooms as (select
(event_inputs:to) as minters,
count(*) as minted_shrooms
from ethereum.core.fact_event_logs
where event_inputs:from='0x0000000000000000000000000000000000000000'
and contract_address='0xdfb57b6e16ddb97aeb8847386989f4dca7202146' and tx_status='SUCCESS'
GROUP BY minters
order by minted_shrooms desc)
select case
when minted_shrooms='2' then 'minted 2 ShroomDK NFTs'
when minted_shrooms='1' then 'minted 1 ShroomDK NFTs' end as how_many_they_minted,
count(minters) as owners
from shrooms
group by how_many_they_minted