I have a working query, but would like to see totals in it - could you advise whether that's possible?

Query is below, and screenpic of results is attached.

SELECT ddef.Deptname, chdt.CHANGEID "Change ID", CTDef.Name "Change Type", longtodate(chdt.Createdtime) "Create Date", priodef1.PRIORITYNAME "Priority", chdt.TITLE "Title" FROM ChangeDetails chdt LEFT JOIN PriorityDefinition priodef1 ON chdt.PRIORITYID=priodef1.PRIORITYID LEFT JOIN Userdepartment usd ON chdt.TECHNICIANID=usd.Userid LEFT JOIN Departmentdefinition ddef ON usd.Deptid=ddef.Deptid LEFT JOIN Changetypedefinition CTDef ON chdt.ChangeTypeID=CTDef.ChangeTypeID ORDER BY 1, 2, 3, 4

ALSO...

is it possible to represent a custom query with one of the chart options in SD+ (pie/bar/line graph)?

Thank you