0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

SELECT 
  1.000*datepart(year,p.CreationDate)+1.000*datepart(month,p.CreationDate)/12 as [date],
  OwnerUserId,
   count(Id)
FROM PostsWithDeleted p
WHERE 
  p.PostTypeId in (2) AND 
  p.CreationDate BETWEEN '2012'+'-01-01' AND '2019'+'-11-2'
  and 
  OwnerUserId in (164061,101426,36041)
GROUP BY 
  1.000*datepart(year,p.CreationDate)+1.000*datepart(month,p.CreationDate)/12,
  OwnerUserId
ORDER BY 
  1.000*datepart(year,p.CreationDate)+1.000*datepart(month,p.CreationDate)/12

fork query

edited nov 8 19 anonymous

created sep 8 15 Jon "not doe" Ericson