I have a report that lists all of our Incident Templates, their created date, and what the Resolution is pre-filled as:

SELECT rtl.Templatename "Template Name", longtodate(rtl.createdtime) "Created Time", rtf.Resolution "Default Resolution" FROM RequestTemplate_list rtl

LEFT JOIN RequestTemplate_Fields rtf ON rtl.TEMPLATEID=rtf.TEMPLATEID 

ORDER BY 1

I need to add the following fields into this, and I'm not sure how.

Could somebody please amend my report