Custom query report

Is it possible to generate report with the time that the ticket assigned to a group? If possible, could you give me mysql query?

Regards,
Sakonrat