with devs as (
select
author,
org,
count(distinct id) as pull_reqs,
count(distinct repo) as repos
from near.beta.github_activity
where author not like '%bot%' -- exclude all bots
group by 1, 2
)
select
'TOP 10 PR creators' as contributors_type
,*
from devs
order by pull_reqs DESC
limit 10