1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

WITH sq1 AS (
  SELECT
      a.Id
    , CASE WHEN q.AcceptedAnswerId IS NULL THEN 0 ELSE 1 END answered
    , CASE WHEN q.AcceptedAnswerId = a.Id THEN 1 ELSE 0 END mine
  FROM
      Posts a
  INNER JOIN
      Posts q
  ON
      a.ParentId = q.Id
  WHERE
      a.OwnerUserId = ##UserId##
)
SELECT
    SUM(sq1.answered) AS answered
  , SUM(sq1.mine) AS mine
FROM
    sq1

view current version

edited may 12 19

created may 12 19 fra-san