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