I need a custom query report that displays all current changes, in which the technician assigned Role associated with the current Stage of the change are only members of a specific Support Group.

Display Columns: ChangeID, Change Title, Created Time, Stage, Technician currently assigned to Role of the active Stage of Change (exp: Change Stage = Implementation | Implementer Role Assigned to: "John Doe" | Display: John Doe) only for members of a specific Support Group.  

Version: 9.4

Build: 9411

Database: MSSQL

Thank you.