How Journey specific task with performer as AOR shall be reassigned to newperson when AOR is reasign

How Journey specific task with performer as AOR shall be reassigned to a new person when the AOR is reassigned

For example - HRBP AOR is assigned to an employee 'A' and list of journey task 150 tasks are assigned to 'A' to perform and complete as HRBP

when the HRBP AOR is reassigned to B, how we can reassign that 150 tasks from A to B

Please also help me with SQL Query to identify the list of tasks assigned to A for the list of employees

Thanks in advance