Adding A Group By Clause And Getting A Count Of A Group

Hi

I am new to SQL and am having a problem. I need to fix my query to do the following...

2) get a total of the number of rows returned.


DECLARE @StartDate varchar(12)
DECLARE @EndDate   varchar(12)
DECLARE @Region    varchar(20)

SET @StartDate = '01/01/2002'
SET @EndDate   = '12/31/2008'
SET @Region    = 'Central'

SELECT
A.createdon,
A.casetypecodename,
A.subjectidname,
A.title,
A.accountid,
A.customerid,
A.customeridname,
B.new_Region,
B.new_RegionName

FROM  dbo.FilteredIncident A
INNER JOIN dbo.FilteredAccount B ON A.customerid = B.accountid

WHERE (A.createdon >=@StartDate  AND A.createdon <= @EndDate)
AND   (B.new_RegionName = @Region)
AND   (A.casetypecode = 2)