SELECT a.Id AS [Post Link], a.LastEditDate, ar.[Accept Ra...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

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],
      OwnerUserId
    FROM
        posts AS p
    WHERE p.PostTypeId=1
    GROUP BY p.OwnerUserId
  ) AS ar ON q.Id=ar.OwnerUserId
WHERE
    q.AcceptedAnswerId IS NULL
  AND a.OwnerUserId = ##UserId##
  AND 0.334 >= ar.[Accept Rate]

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results