I'm looking for a query to count how many times a request has been re-opened. I'm not sure if it's possible.

Really appreciate your help..