Don't think you can achieve this with a query, however it would certainly be possible with a Crystal Report.
You would probably want to pull all the records for a date range and the group of analysts your interested in (can be parameters when running the report) then use a cross tab report to display the information.
You might have to use some crystal calculations in order to get the week number of a resolution date to use in the cross tab.
Thanks you smiddleton you advise was really good.
I ended up creating a query that was based on the resolution create data using parameter to filter, grouped by analyst and filter on incidents and services requests (two separate querys for incidents and SR) in LANDesk as a work around.
You are absolutely right, in order to achieve the wk1, wk2, and the count, crosstab look and feel would need to implement in a crystal report.