Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
167 B
5
Indexable
Never
select distinct cast(date_trunc('month', created_at) as date), 
count(user_id) over(partition by cast(date_trunc('month', created_at) as date))
from tools_shop.users