Skip to content

Instantly share code, notes, and snippets.

@dorkness-io

dorkness-io/having.sql

Created April 9, 2020 13:31
Show Gist options
  • Save dorkness-io/ef386d5b9b0b41cc1578666d9ad2ba71 to your computer and use it in GitHub Desktop.
Save dorkness-io/ef386d5b9b0b41cc1578666d9ad2ba71 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
having.sql
select
p.pkey || '-' || ji.issuenum AS issue_key
from jiraissue ji
join project p
on ji.project = p.id
join jiraaction ja
on ji.id = ja.issueid
and actiontype = 'comment'
group by 1
having count(ja.id) >= 10;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment