select right(year_month,4) year, left(year_month,len(year...


Please login or register to vote for this query.

(click on this box to dismiss)

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

select right(year_month,4) year,
  left(year_month,len(year_month)-4) month, 
  count(Id) cnt
from (
  select Id, PostTypeId,
  FORMAT(CreationDate, N'MMMM yyyy', 'en-US') year_month
  from Posts
  ) t1
where PostTypeId='1' 
group by year_month
order by cnt

Enter Parameters

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