0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT 
    a.Id AS [Post Link], a.LastEditDate, ar.[Accept Rate]
FROM
    Posts AS a
  JOIN
    Posts AS q ON a.ParentId = q.Id
  JOIN
    Users AS u ON q.OwnerUserId=u.Id
  JOIN (
    SELECT
      Sum(CASE WHEN p.AcceptedAnswerId IS NULL THEN 0 ELSE 1 END) / Cast(COUNT(p.Id) AS Float) AS [Accept Rate],
      Count(p.Id) AS [Total Questions],
      OwnerUserId
    FROM
        posts AS p
    WHERE p.PostTypeId=1
    GROUP BY p.OwnerUserId
    HAVING Count(p.Id) > 5
  ) AS ar ON q.OwnerUserId=ar.OwnerUserId
WHERE
    q.AcceptedAnswerId IS NULL
  AND a.OwnerUserId = ##UserId##
ORDER BY ar.[Accept Rate] ASC

fork query

created dec 2 10 ww.galen