select FORMAT(CreationDate,'MMM yyyy'),count(distinct Id)...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select FORMAT(CreationDate,'MMM yyyy'),count(distinct Id) as "Number of posts"
from Posts
group by FORMAT(CreationDate,'MMM yyyy')
order by FORMAT(CreationDate,'MMM yyyy')

Enter Parameters

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