SELECT DISTINCT A.wallet_id, A.new_kyc_type, A.reactivated_on , B.otp_date FROM (SELECT DISTINCT wallet_id, new_kyc_type, Date(created_at) as reactivated_on FROM wallet.wallet_audit WHERE year IN (2021, 2022) AND old_wallet_state <> new_wallet_state AND new_wallet_state = 'ACTIVATED')A LEFT JOIN (SELECT DISTINCT wallet_id, Date(created_at) as otp_date FROM wallet.wallet_hurdle_details WHERE year IN (2021, 2022) AND action = 'REVERT_WALLET_INACTIVE_STATE' AND hurdle_type = 'OTP')B ON A.wallet_id = B.wallet_id WHERE A.reactivated_on < B.otp_date
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter