Finding No. Issues for every project

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