badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Board and Card Games

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

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

--3
--select* from Posts


--select format(CreationDate,'yyyy') as year,
--format(CreationDate,'MM') as month,
--PostTypeId as posttypeid,
--count(id) as cnt
--from Posts
--group by format(CreationDate,'yyyy'),format(CreationDate,'MM'),PostTypeId 
--having PostTypeId =1 
--order by cnt desc

Enter Parameters

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