SQL to find the representatives of an active employee's assignment record

Summary

SQL to find the representatives of an active employee's assignment record

Content

Hi Experts,

I am looking for the AoR report that fetches all the active employee records and their associated representatives.

For Example:

If John is the Human Resource Rep for Michael and Nick is the Benefits Rep for Michael. Then the report should be in the below format

Employee Name	Employee Person Number	Employee Assignment Number	Representative Person Name	Representative Person Number	Representative Responsibility Type	From Date	End Date
Michael	110101	E110101	John	220022	Human Resource Representative	01/01/2021
Michael	110101	E110101	Nick	220023	Benefits Representative	01/01/2021

If you have SQL that can fetch the report in the above format or similar to this one, Please share.