Q&A for scientists using computers to solve scientific problems
WITH questionsWithAnswers AS( SELECT AcceptedAnswerId FROM Posts WHERE PostTypeId = 1 AND AcceptedAnswerId IS NOT NULL ) SELECT top 400 p.Id, p.Score, p.ViewCount, p.OwnerUserId, p.CommentCount, p.FavoriteCount, (CASE WHEN EXISTS(SELECT 1 FROM questionsWithAnswers qa WHERE qa.AcceptedAnswerId = p.id) THEN 1 ELSE 0 END) AS IsAcceptedAnswer from posts p where postTypeId = 2