SELECT BRANCH,COUNT(DISTINCT BRANCH), SUM(CASE WHEN NOOFDAYSLOS BETWEEN 7 AND 30 THEN 1 ELSE 0 END)'Over a week',
		  	SUM(CASE WHEN NOOFDAYSLOS BETWEEN 30 AND 90 THEN 1 ELSE 0 END)'Over 30 Days',
		       	SUM(CASE WHEN NOOFDAYSLOS BETWEEN 91 AND 180 THEN 1 ELSE 0 END)'Over 90 Days'

		    	FROM DETAILS	
			WHERE DATERECEIVED BETWEEN @FromDate AND @ToDate and STATUS = 'C'
			GROUP BY BRANCH,DATERECEIVED
			ORDER BY BRANCH

I tried using the above code but it did'nt work out.

Plz Can SomeOne Find an Appropriate Solution.
                                                 Thanks In Advance..