I have three grouped sql statements that i want to combine in to one sql. Iam using SQL Server 2012. Here is an example : --ON TIME PMWO's 

SELECT LOCATION, COUNT(WONUM) AS  OnTimePMWOs
FROM
WORKORDER
WHERE   worktype = 'pm' and actfinish<=targcompdate
GROUP BY LOCATION
--PAST DUE PMWO'S

SELECT LOCATION, COUNT(WONUM) AS PastDuePMWOs
FROM
WORKORDER
WHERE  worktype = 'pm' and actfinish>=targcompdate 
GROUP BY LOCATION

--30 DayForecast- 

SELECT W.location, COUNT(W.wonum) AS Forecast30days
from
workorder AS W
INNER JOIN PMFORECAST AS P
ON W.CHANGEDATE=P.CHANGEDATE
WHERE WORKTYPE='PM' AND P.forecastdate>= GETDATE()+30
GROUP BY LOCATION

