waltz
waltz copied to clipboard
Blog post: write up leader board stats
select
[change_log].[user_id],
count([change_log].[user_id]) [count],
row_number() over (order by count([change_log].[user_id]) desc)
from [change_log]
where ([change_log].[created_at] > cast('2021-01-01 00:00:00.0' as datetime))
group by [change_log].[user_id]