Issues submitted vs. issues closed

select count(issues.id) as total_issues, projects.name as project_name, projects.url as project_url from
issues join projects
on issues.repo_id = projects.id
group by projects.id

select count(distinct issues.id) as total_issues, projects.name as project_name, projects.url as project_url 
from    
issues join projects
on issues.repo_id = projects.id
join issue_events
on issue_events.issue_id = issues.id
where issue_events.action = 'closed'
group by projects.id

GHData

Anna Buhman