0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

SELECT 
  1.000*datepart(year,p.CreationDate)+1.000*datepart(week,p.CreationDate)/52 as [date],
  Cast(PostTypeId as Char),
  count(Id)
FROM PostsWithDeleted p
WHERE 
  p.PostTypeId in (1,2) AND 
  p.CreationDate BETWEEN '2014'+'-01-01' AND '2019'+'-10-27'
  and p.ClosedDate is null
GROUP BY 
  1.000*datepart(year,p.CreationDate)+1.000*datepart(week,p.CreationDate)/52,
  PostTypeId
ORDER BY 
  PostTypeId,1.000*datepart(year,p.CreationDate)+1.000*datepart(week,p.CreationDate)/52

fork query

edited nov 16 anonymous

created sep 8 15 Jon "not doe" Ericson