select rt.requestType, rt.requestTypeName, coalesce( rt.requestTypeName, rt.requestType ) requestTypeDisplay, count(*) requestCount
from tbl_WRK_UserRequests ur
inner join tbl_WRK_UserRequestTypes rt
on rt.userRequestTypeId = ur.userRequestTypeId
where ur.ownerId =
and ur.ownerType =
and ur.disposition = '?'
and ur.toUserId =
group by rt.requestType, rt.requestTypeName
order by requestTypeDisplay