select format(CreationDate,'yyyy.MM') as date,count(Id) a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

German Language Meta

Q&A about the site for speakers of German wanting to discuss the finer points of the language and translation

select format(CreationDate,'yyyy.MM') as date,count(Id) as number_of_posts
from Posts
group by format(CreationDate,'yyyy.MM')

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results