select

block_timestamp::date as date,

tx_hash,

event_inputs:creator::string as creator,

event_inputs:tokenId::string as tokenID,

CASE

when date >= CURRENT_DATE - 90 THEN 'In past 3 months'

when date < CURRENT_DATE - 90 THEN 'Before past 3 months'

END as label

from Ethereum_core.fact_event_logs

where date >= CURRENT_DATE - 180

and contract_address = '0x3b3ee1931dc30c1957379fac9aba94d1c48a5405'

and event_name = 'Minted'

select date, label, count(tx_hash) as mints_count

from mints

group by 1,2

order by 1