repo as repository,

count(distinct id) as activities_count,

count(distinct author) as developers_count

from near.beta.github_activity

group by 1

order by developers_count desc

limit 10