Query: open_pull_request_count

select
  count(*) as value,
  'Open PRs' as label
from
  github_my_repository r
  join github_pull_request p on p.repository_full_name = r.name_with_owner
where
  p.state = 'OPEN';