waltz icon indicating copy to clipboard operation
waltz copied to clipboard

Blog post: write up leader board stats

Open davidwatkins73 opened this issue 3 years ago • 0 comments

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]

davidwatkins73 avatar Nov 20 '21 11:11 davidwatkins73