repo as repository,

count(distinct id) as activities_count,

iff(repository in ('near-wallet', 'wallet-app'), 'Before', 'After') as value,

count(distinct author) as developers_count

from near.beta.github_activity

group by 1, value

order by activities_count desc

limit 10