instruction: My winner and loser answers.
response: SELECT CASE WHEN Q.AcceptedAnswerId = A.Id THEN 'Winner' WHEN Q.AcceptedAnswerId IS NULL THEN '...' ELSE 'Loser' END AS Status, A.Id AS "post_link", A.Score, CASE WHEN A.Id != W.Id THEN W.Score ELSE NULL END AS "winner_score", CASE WHEN A.Id != W.Id THEN (SELECT MAX(Posts.Score) FROM Posts WHERE ParentId = Q.Id) ELSE NULL END AS "max_score", A.CreationDate AS "date", Q.LastActivityDate FROM Posts AS A JOIN Posts AS Q ON Q.Id = A.ParentId LEFT JOIN Posts AS W ON W.Id = Q.AcceptedAnswerId WHERE A.OwnerUserId = '##UserId##' ORDER BY Score DESC