Total count on a query
Hi all, i have the following query but would like to place a count of the total number of tickets resolved.
What would be the best way to achieve this please.
Thanks in advance
What would be the best way to achieve this please.
Thanks in advance
select MAX(aaa.first_name) "Resolved By", COUNT(Distinct workorderid) "Count of requests" from workorderhistory woh left join aaauser aaa on woh.Operationownerid=aaa.user_id where (operation='Resolved' or operation='CLOSE' )
and
(
aaa.first_name like '%
tech1%' or
aaa.first_name like '%
tech2%' or
aaa.first_name like '%
tech3%'
)
and woh.OperationTIME >= <from_lastweek> AND woh.OperationTIME <= <to_lastweek> GROUP BY aaa.USER_ID