SELECT a.Id AS [Post Link], a.LastEditDate FROM Posts AS ...

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
FROM
    Posts AS a
  JOIN
    Posts AS q ON a.ParentId = q.Id
  JOIN
    Users AS u ON q.OwnerUserId=u.Id
WHERE
    q.AcceptedAnswerId IS NULL
  AND a.OwnerUserId = ##UserId##
  AND 0.334 >= (
    SELECT
      Sum(CASE WHEN p.AcceptedAnswerId IS NULL THEN 0 ELSE 1 END) / Cast(COUNT(p.Id) AS Float) AS [Accept Rate]
    FROM
        posts AS p
    WHERE
        p.PostTypeId=1
      AND p.OwnerUserId=u.Id
  )

Enter Parameters

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