repo as repository,

iff(charindex('/issues/', url) > 0, substring(url, 0, charindex('/issues/', url)), substring(url, 0, charindex('/pull/', url))) as url,

count(distinct id) as activities_count,

count(distinct author) as developers_count

from near.beta.github_activity

group by 1, 2

order by developers_count desc

limit 10