SLA Report

Could someone provide the MSSQL code to produce the following report which is based on closed requests?

I would like two versions, one for the previous week and one for the previous month.

Priority Requests SLA %
1 5 100%
2 20 90%
3 150 75%

Thanks in advance.

Rohan