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. 

                  New to ADSelfService Plus?