0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for power users of Apple hardware and software

select cast(posts.creationDate as date), 
ownerdisplayname, 
count(distinct posts.id), 
rank() over(partition by cast(posts.creationDate as date) order by count(distinct posts.id)) 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), ownerdisplayname
having count(distinct posts.id) > 5
order by cast(posts.creationDate as date) asc

fork query

edited jun 20 18

created jun 20 18 anonymous