MySQL
-- Project Updated last 30 days
SELECT project.pname as "Project", COUNT(jiraissue.pkey) AS "Issue Updated Last 30 Days"
FROM jiraissue RIGHT OUTER JOIN
project ON jiraissue.PROJECT = project.ID AND jiraissue.UPDATED > now() - 30
GROUP BY project.pname
ORDER BY "Issue Updated Last 30 Days";