0

Please login or register to vote for this query.

(click on this box to dismiss)

On avg how often are answers I give, accepted

Q&A for professional and enthusiast programmers

-- What is my accepted answer percentage rate
-- On avg how often are answers I give, accepted

DECLARE @UserId int = ##UserId##;



with x AS (
SELECT 
DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1) mm
FROM
   Posts a 
WHERE
    a.OwnerUserId = @UserId
  AND
    a.PostTypeId = 2
    )
    
    select mm, count(*) 
    from x
    group by mm
    order by 1 desc

fork query

edited jan 28 Felipe.Hoffa35541

created may 25 10 sam.saffron