Resolved and Closed by Report

Hi,

Can you provide me the SQL query to generate this report:

For all tickets with "Closed" Status from <Date> to <Date>, I'd like to extract the Support Group and Technician that was assigned to the Ticket at the time it was put into "Resolved" Status and then "Closed" Status.

The fields I'd like are:

Request ID,
Date and Time Ticket was created
Date and Time Ticket was put into Resolved Status
Support Group at the time Ticket was put into Resolved Status
Technician assigned at the time Ticket was put into Resolved Status
Date and Time Ticket was put into Closed Status
Support Group at the time Ticket was put into Closed Status
Technician assigned at the time Ticket was put into Closed Status
Category
Sub-Category
Item

We're using version 8.1.0 Build 8109.

Thanks in advance.