SELECT

COUNT(C.[Place Referance]) AS [April Total Voids],

SUM(CASE WHEN [Void End Date] IS NULL THEN 1 ELSE 0 END) AS [April_Still_Voids]

FROM

(

SELECT DISTINCTTOP 100 PERCENT

HIST.[PLACE-REF] AS 'Place Referance'

,PLA.[address1] AS 'Address Line1'

,HIST.[START-DATE] AS 'Void Start Date'

,HIST.[END-DATE] AS 'Void End Date'

,HIST.[END-DATE]+1 AS 'Start Of Tenancy'

,LOC.[mgt-area] AS 'Managment Area'

,LOC.[scheme] AS 'Scheme'

,LOC.[location-sts] AS 'Location Status'

,LOC.[location-type] AS 'Location Type'

,DATEPART(MM,HIST.[START-DATE]) AS 'Void Start Date MONTH'

,DATEPART(YYYY, HIST.[START-DATE]) AS 'Void Start Date YEAR'

FROM[dbo].[IH_IH-LOCATION-HIST] AS HIST

INNER JOIN

[dbo].[IH_IH-LOCATION] AS LOC

ONHIST.[PLACE-REF] = LOC.[place-ref]

INNER JOIN

DBO.[CORE_CO-PLACE] AS PLA

ONHIST.[PLACE-REF] = PLA.[place-ref]

WHEREHIST.[LOCATION-STS] = 'V'

AND HIST.[START-DATE] BETWEEN CONVERT(DATETIME, '2014-04-01 00:00:00', 102) AND CONVERT(DATETIME, '2015-03-31 00:00:00', 102)

AND LOC.[location-type] <> 'D'

AND LOC.[location-type] <> 'Garage'

ORDER BY [Place Referance]

) AS C

WHERE [Void Start Date YEAR] = '2014'

AND [Void Start Date MONTH] = '4'