SELECT DISTINCT eventdata_globalcardid, eventdata_tokenid, 
IF(eventtype = 'CARD_UNSTAGED', 'CARD_ADDED_PRE_TOKENIZATION', eventtype) AS event, 
eventdata_merchanttransactionid, year, month, day FROM foxtrot_stream.vault_default 
WHERE year = 2022 AND eventtype IN ('USER_CARD_DELETED', 'CARD_UNSTAGED', 'TOKEN_REGISTERED', 'TOKEN_DELETE')
AND ((eventdata_userid = 'U1612041824331881735953') OR (eventdata_merchantuserid = 'U1612041824331881735953'))
ORDER BY year, month, day