OUTPUT:

select wo.WORKORDERID "Request ID",
wo.title "Subject",
rrs.resolution "Resolution",
au.FIRST_NAME "Resolved by" from WorkOrder wo

LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID

LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID

LEFT join Workorderhistory wh on wo.workorderid = wh.WORKORDERID

LEFT JOIN SdUser sd on wh.OPERATIONOWNERID = sd.USERID
LEFT JOIN AAAUSER au on sd.userid = au.USER_ID

where wo.isparent = '1' and wh.operation = 'RESOLVED' and wo.createdtime > <from_thismonth> and wo.createdtime < <to_thismonth>

Note: Using this query without filter or criteria will cause performance issue.