To display issue resolution you can use next query
select i.`KEY` as Issue, ir.NAME as `Resolution` from ISSUE i join ISSUERESOLUTION ir on i.RESOLUTIONID=ir.ID where JQL='project=PROJECTNAME AND resolution is not EMPTY'
To display issue resolution you can use next query
select i.`KEY` as Issue, ir.NAME as `Resolution` from ISSUE i join ISSUERESOLUTION ir on i.RESOLUTIONID=ir.ID where JQL='project=PROJECTNAME AND resolution is not EMPTY'