Query for Completed Request

Query for Completed Request

I'm not able to create a report for what I need but I'm hoping a query can.

I'd like to be able to see request that have been completed either with Resolved and/or Closed. But then at some point those request changed Technician after it was already completed. And I'd like to see what technician it was with and then who it went to.