Page Comparison

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'

PROJECTNAME* is a tentative name in our queries. Please note that in your JQLs you need to use real names of your Projects, Users, Sprints ,etc.