when (event_name = 'Stake' or event_name = 'Staked') THEN 'Stake_action'

when event_name = 'Unstake' THEN 'Unstake_action'

when (event_name ilike '%Swap%' or event_name ilike 'TokenExchange') then 'Swap_action'

when (event_name = 'AddLiquidity' or event_name = 'IncreaseLiquidity') THEN 'Add_Liquidity'

when (event_name ='DecreaseLiquidity' OR event_name ilike 'RemoveLiquidityOne') THEN 'Remove_Liquidity'

when tx_hash IN (SELECT distinct tx_hash from optimism.core.ez_nft_sales) then 'NFT'

when tx_hash in (SELECT distinct tx_hash from optimism.core.fact_delegations) then 'Delegation'

else 'other_actions'

end as type, count (distinct origin_from_address) as num_users,

COUNT(distinct tx_hash) as num_transactions

FROM optimism.core.fact_event_logs

WHERE event_name is not null AND tx_hash IN (SELECT distinct transaction_id

FROM (SELECT distinct tx_hash as transaction_id FROM optimism.core.fact_event_logs

WHERE tx_status ilike 'SUCCESS' AND contract_address ilike '0x4200000000000000000000000000000000000042'))

and block_timestamp >= '{{Start_Date}}'and block_timestamp <= CURRENT_DATE - 1

GROUP BY 1