How Journey task with performer as AOR shall be reassigned to a new person when AOR changes

Summary:

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

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):