SELECT

date_trunc('day', block_timestamp) as day,

count(CASE WHEN method_name LIKE 'nft_mint' THEN 1 END) as nft_mints,

count(CASE WHEN method_name LIKE 'nft_buy' THEN 1 END) as nft_buys

FROM near.core.fact_actions_events_function_call

WHERE (method_name LIKE 'nft_mint'

OR method_name LIKE 'nft_buy')

GROUP BY 1

SELECT *

FROM tab1

WHERE day > '2022-01-01'