badges

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

--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 main site
loading Hold tight while we fetch your results