MySQL
-- 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);
-- 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);