MySQL / PostgreSQL
Code Block | ||
---|---|---|
| ||
-- Issue Count Per Project SELECT p.pname AS "Project Name", p.pkey AS "Project Key", COUNT(*) AS "No. Issue" FROM jiraissue ji INNER JOIN project p ON ji.project = p.ID GROUP BY p.pkey, p.pname; |
...
Code Block | ||
---|---|---|
| ||
-- Issue Count Per Project SELECT p.pname AS "Project Name", p.pkey AS "Project Key", COUNT(*) AS "No. Issue" FROM jiraissue ji INNER JOIN project p ON ji.project = p.ID GROUP BY p.pkey, p.pname; |
...