shreexHow Many ShroomDK NFTs Minted By Minters
    Updated 2022-07-02
    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
    Run a query to Download Data