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;