SELECT

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')

AND block_timestamp > '2022-01-01'

SELECT *

FROM tab1