Group By Week

Hi,
I have a table that has the following fields

Date entered date closed Status Name


I need to write a query to pick the records which are not closed, but are
open for more than 7 days and then group them by week. Here is an example of
what I am looking for

Date Entered date closed Status Name
4/13 open Test
4/22 open test2


The query should return
for week
16 count of open tickets as 1
17 count of open tickets as 2

I can do it for the current week, but I want to leave the historical data,
like if someone wants to check the number of tickets open in week 16 then
should be able to. Here is my DDL for the current week


SELECT YEAR(dbo.v_SR_Board_ByCompany.date_entered) AS Year,
MONTH(dbo.v_SR_Board_ByCompany.date_entered) AS Month,
dbo.v_SR_Board_ByCompany.date_entered,
dbo.v_SR_Board_ByCompany.date_closed, dbo.v_SR_Board_ByCompany.summary,
dbo.SR_Status.Description AS Status, ROUND(DATEDIFF(s,
dbo.v_SR_Board_ByCompany.date_entered, GETDATE()) / (60 * 60 * 24), 0)
AS closeduration, { fn WEEK(GETDATE()) } AS Week,
dbo.v_SR_Board_ByCompany.Board_Name
FROM dbo.v_SR_Board_ByCompany INNER JOIN
dbo.Company ON dbo.v_SR_Board_ByCompany.company_recid
= dbo.Company.Company_RecID INNER JOIN
dbo.SR_Status ON
dbo.v_SR_Board_ByCompany.sr_status_recid = dbo.SR_Status.SR_Status_RecID
GROUP BY YEAR(dbo.v_SR_Board_ByCompany.date_entered),
MONTH(dbo.v_SR_Board_ByCompany.date_entered),
dbo.v_SR_Board_ByCompany.date_entered,
dbo.v_SR_Board_ByCompany.date_closed, dbo.v_SR_Board_ByCompany.summary,
dbo.Company.Company_Name, dbo.SR_Status.Description,
ROUND(DATEDIFF(s, dbo.v_SR_Board_ByCompany.date_entered, GETDATE())
/ (60 * 60 * 24), 0),
dbo.v_SR_Board_ByCompany.Board_Name
HAVING (dbo.v_SR_Board_ByCompany.Board_Name = 'Corporate/Service') AND
(YEAR(dbo.v_SR_Board_ByCompany.date_entered) > 2007) AND
(dbo.SR_Status.Description <> 'closed')

Is there a way to do this???


Thanks
Shri