Q1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

select cast(posts.creationDate as date), 
OwnerUserId, 
count(distinct posts.id), 
rank() over(partition by cast(posts.creationDate as date) order by count(distinct posts.id) desc) as rnk
from posts
where cast(posts.creationDate as date) between '2018-01-01' and '2018-01-05'
group by cast(posts.creationDate as date), OwnerUserId
having count(distinct posts.id) > 5
order by cast(posts.creationDate as date) asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results