repo as repository,

substring(url, 0, charindex('/issues/', url)) as url,

count(distinct id) as issue_openers_count

from near.beta.github_activity

where contains(url, '/issues/')

group by 1, 2

order by issue_openers_count desc

limit 10