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 ownerUserId, count(distinct posts.id)
from posts
where cast(posts.creationDate as date) = '2018-01-01'
group by ownerUserId
having count(distinct posts.id) > 1
order by count(distinct posts.id) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results