Verificando se esta sendo Work Orders de PMs

SELECT WONUM,STATUS,WORKTYPE,DESCRIPTION,LOCATION,JPNUM,PMNUM,ROUTE,REPORTDATE,REPORTEDBY
FROM workorder w
WHERE pmnum IS NOT NULL
AND istask = 0
order by reportdate desc

Contando a quantidade

SELECT REPORTDATE,REPORTEDBY,count(1) as CNT
FROM workorder w
WHERE pmnum IS NOT NULL
AND istask = 0
group by  REPORTDATE,REPORTEDBY
order by reportdate desc

Ver também