Problem and Change Timespent reports

I need to be able to create Problem and Change Timespent reports, summarized by technician for the last week.

What SQL code can I use to do this?